DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on CS_SR_EVENT_CODES_B

Line 791: CS_SR_EVENT_CODES_B cec

787: SELECT csat.INCIDENT_STATUS_ID
788: --INTO l_status_id
789: FROM CS_SR_ACTION_TRIGGERS csat,
790: CS_SR_ACTION_DETAILS csad,
791: CS_SR_EVENT_CODES_B cec
792: WHERE
793: cec.WF_BUSINESS_EVENT_ID = 'oracle.apps.cs.sr.ServiceRequest.statuschanged'
794: and csat.EVENT_CODE = cec.EVENT_CODE
795: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))