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
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 |