BEN Communications Triggers Summary

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Advanced Benefits
Source
Communications Triggers Summary Report (XML)
Short Name
BENCMSUM_XML
DB package
BEN_BENCMSUM_XMLP_PKG

SQL 12 lines

            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

Parameters 1

ParameterTypeList of values SQL
Concurrent Request IDLOV Oracle