BEN Process Forfeitures Summary
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Process Forfeitures Summary Report (XML)
Short Name: BENFRSUM_XML
DB package: BEN_BENFRSUM_XMLP_PKG
Source: Process Forfeitures Summary Report (XML)
Short Name: BENFRSUM_XML
DB package: BEN_BENFRSUM_XMLP_PKG
Run
BEN Process Forfeitures Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select pl.name PLAN_NAME , rpt.val pl_total_frfd_val, rpt.ler_id pl_cntr_val, related_person_id pl_distr_val from ben_reporting rpt, ben_benefit_actions bba, ben_pl_f pl where rpt.rep_typ_cd IN ('FRPLVAL') and bba.request_id = :P_CONCURRENT_REQUEST_ID and bba.benefit_action_id = rpt.benefit_action_id and rpt.pl_id = pl.pl_id and sysdate between pl.effective_start_date and pl.effective_end_date order by pl.name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Concurrent Request ID |
|
LOV Oracle |