Reports2017-11-18T12:27:27+00:00

BEN Close Enrollments Summary

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Close Enrollments Summary Report (XML)
Short Name: BENCLSUM_XML
DB package: BEN_BENCLSUM_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 = 'ERROR'
group by REP.ERROR_MESSAGE_CODE
Parameter Name SQL text Validation
Concurrent Request ID
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept