BEN Process Forfeitures Audit Log

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Process Forfeitures Audit Log (XML)
Short Name: BENFRAUD_XML
DB package: BEN_BENFRAUD_XMLP_PKG
Run BEN Process Forfeitures Audit Log and other Oracle EBS reports with Blitz Report™ on our demo environment
select per.full_name Person_NAME ,
           rpt.val per_frfd_val,
           rpt.ler_id per_cntr_val,
           related_person_id per_distr_val,
           rpt.pl_id pl_idm2
from ben_reporting rpt,
     ben_benefit_actions bba,
     per_all_people_f per
where  rpt.rep_typ_cd IN ('FRPERPLVAL')
  and bba.request_id =   :P_CONCURRENT_REQUEST_ID
  and bba.benefit_action_id = rpt.benefit_action_id
  and rpt.person_id = per.person_id
  and sysdate between
      per.effective_start_date and per.effective_end_date 
 and rpt.pl_id=:pl_id1
order by per.last_name
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Download
Related Blitz Reports
BEN Back-out Life Events Audit Log BEN Close Enrollments Audit Log BEN Communications Triggers Audit Log BEN Error By Person Report(Comm.) BEN Error Type BEN Person Error BEN Error By Error Type Report(Comm.) BEN Back-out Life Events Summary BEN Default Enrollment Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: