BEN Process Forfeitures Audit Log

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