BEN Process Forfeitures Audit Log

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Process Forfeitures Audit Log (XML)
Short Name: BENFRAUD_XML
DB package: BEN_BENFRAUD_XMLP_PKG
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 NameSQL textValidation
Concurrent Request ID
 
LOV Oracle