BEN Communications Triggers Summary

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Communications Triggers Summary Report (XML)
Short Name: BENCMSUM_XML
DB package: BEN_BENCMSUM_XMLP_PKG
            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