BEN Dependent Eligibility Summary

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Advanced Benefits
Source
Dependent Eligibility Summary Report (XML)
Short Name
BENDESUM_XML
DB package
BEN_BENDESUM_XMLP_PKG

SQL 9 lines

            select REP.ERROR_MESSAGE_CODE,
                      COUNT(REP.ERROR_MESSAGE_CODE) NUMBER_OF_ERROR_CODES
                      from   BEN_REPORTING REP,
                      BEN_BENEFIT_ACTIONS BFT
            where BFT.BENEFIT_ACTION_ID = REP.BENEFIT_ACTION_ID
            and bft.request_id = :P_CONCURRENT_REQUEST_ID
            and rep.rep_typ_cd in 'ERROR'
            group by REP.ERROR_MESSAGE_CODE

Parameters 1

ParameterTypeList of values SQL
Concurrent Request IDLOV Oracle