BEN Dependent Eligibility Summary

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Dependent Eligibility Summary Report (XML)
Short Name: BENDESUM_XML
DB package: BEN_BENDESUM_XMLP_PKG
            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
Parameter Name SQL text Validation
Concurrent Request ID
 
LOV Oracle