[Home] [Help]
479: SELECT csat.INCIDENT_STATUS_ID
480: --INTO l_status_id
481: FROM CS_SR_ACTION_TRIGGERS csat,
482: CS_SR_ACTION_DETAILS csad,
483: CS_SR_EVENT_CODES_B cec
484: WHERE
485: cec.WF_BUSINESS_EVENT_ID = 'oracle.apps.cs.sr.ServiceRequest.statuschanged'
486: and csat.EVENT_CODE = cec.EVENT_CODE
487: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))