BEN Close Action Items Summary

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Advanced Benefits
Source
Close Action Items Summary Report (XML)
Short Name
BENUASUM_XML
DB package
BEN_BENUASUM_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