BEN Close Action Items Summary

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Close Action Items Summary Report (XML)
Short Name: BENUASUM_XML
DB package: BEN_BENUASUM_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
Ask a question