APPS.CSD_PROCESS_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 7672: FROM cs_incident_statuses_vl

7668: -- first valid closed status.
7669: BEGIN
7670: SELECT name
7671: INTO l_sr_status
7672: FROM cs_incident_statuses_vl
7673: WHERE incident_subtype = 'INC'
7674: AND CLOSE_FLAG = 'Y'
7675: AND TRUNC(SYSDATE) BETWEEN
7676: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7693: FROM cs_incident_statuses_vl

7689: status 'Close' in local language.
7690: */
7691: SELECT name
7692: INTO l_sr_status
7693: FROM cs_incident_statuses_vl
7694: WHERE incident_subtype = 'INC'
7695: AND CLOSE_FLAG = 'Y'
7696: AND TRUNC(SYSDATE) BETWEEN
7697: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7908: FROM cs_incident_statuses_vl

7904: -- first valid closed status.
7905: BEGIN
7906: SELECT name
7907: INTO l_sr_status
7908: FROM cs_incident_statuses_vl
7909: WHERE incident_subtype = 'INC'
7910: AND CLOSE_FLAG = 'Y'
7911: AND TRUNC(SYSDATE) BETWEEN
7912: TRUNC(NVL(start_date_active, SYSDATE)) AND

Line 7929: FROM cs_incident_statuses_vl

7925: status 'Close' in local language.
7926: */
7927: SELECT name
7928: INTO l_sr_status
7929: FROM cs_incident_statuses_vl
7930: WHERE incident_subtype = 'INC'
7931: AND CLOSE_FLAG = 'Y'
7932: AND TRUNC(SYSDATE) BETWEEN
7933: TRUNC(NVL(start_date_active, SYSDATE)) AND