DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 7517: FROM cs_incident_statuses_vl

7513: -- first valid closed status.
7514: BEGIN
7515: SELECT name
7516: INTO l_sr_status
7517: FROM cs_incident_statuses_vl
7518: WHERE incident_subtype = 'INC'
7519: AND CLOSE_FLAG = 'Y'
7520: AND TRUNC(SYSDATE) BETWEEN
7521: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7538: FROM cs_incident_statuses_vl

7534: status 'Close' in local language.
7535: */
7536: SELECT name
7537: INTO l_sr_status
7538: FROM cs_incident_statuses_vl
7539: WHERE incident_subtype = 'INC'
7540: AND CLOSE_FLAG = 'Y'
7541: AND TRUNC(SYSDATE) BETWEEN
7542: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7753: FROM cs_incident_statuses_vl

7749: -- first valid closed status.
7750: BEGIN
7751: SELECT name
7752: INTO l_sr_status
7753: FROM cs_incident_statuses_vl
7754: WHERE incident_subtype = 'INC'
7755: AND CLOSE_FLAG = 'Y'
7756: AND TRUNC(SYSDATE) BETWEEN
7757: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7774: FROM cs_incident_statuses_vl

7770: status 'Close' in local language.
7771: */
7772: SELECT name
7773: INTO l_sr_status
7774: FROM cs_incident_statuses_vl
7775: WHERE incident_subtype = 'INC'
7776: AND CLOSE_FLAG = 'Y'
7777: AND TRUNC(SYSDATE) BETWEEN
7778: TRUNC(NVL(start_date_active, SYSDATE)) AND