BEN Communications Triggers Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Communications Triggers Summary Report (XML)
Short Name: BENCMSUM_XML
DB package: BEN_BENCMSUM_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

            select cct.name cm_typ_name,
                        count(*)  no_of_cm_typ
            from  ben_benefit_actions bft,
                     ben_batch_commu_info bmi,
                      ben_cm_typ_f    cct
            where bft.request_id = :p_concurrent_request_id
            and   bft.benefit_action_id = bmi.benefit_action_id
            and   bmi.cm_typ_id = cct.cm_typ_id
            and :cp_process_date between
            cct.effective_start_date and cct.effective_end_date
            group by cct.name
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Download
 
Related Blitz Reports
BEN Communications Triggers Audit Log BEN Dependent Eligibility Audit Log BEN Default Enrollment Audit Log BEN Close Action Items Audit Log BEN Participation Process Reports Output BEN Participation Summary BEN COBRA Benefit Notification Letter BEN HIPAA Letter BEN Back-out Life Events Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: