APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 824: FROM CS_INCIDENT_STATUSES_VL

820: END IF;
821:
822: SELECT name
823: INTO l_request_status_temp
824: FROM CS_INCIDENT_STATUSES_VL
825: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
826:
827: IF (l_request_status_temp = l_request_status) THEN
828:

Line 1502: cs_incident_statuses_vl b

1498: -- 3. NTFY_LINK_TYPE
1499: CURSOR sel_linked_sr_details_csr IS
1500: SELECT a.summary, b.name
1501: FROM cs_incidents_all_vl a,
1502: cs_incident_statuses_vl b
1503: WHERE a.incident_status_id = b.incident_status_id AND
1504: a.incident_id = l_request_id;
1505:
1506: sel_linked_sr_details_rec sel_linked_sr_details_csr%ROWTYPE;

Line 5119: FROM CS_INCIDENT_STATUSES_VL

5115: END IF;
5116:
5117: SELECT name
5118: INTO l_request_status_temp
5119: FROM CS_INCIDENT_STATUSES_VL
5120: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
5121:
5122: IF (l_request_status = l_request_status_temp) THEN
5123: WF_ENGINE.SetItemAttrNumber(

Line 6312: CS_INCIDENT_STATUSES_VL STATUS,

6308: --CS_INCIDENT_TYPES_VL TYPE,
6309: CS_INCIDENT_TYPES_TL TYPE,
6310: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6311: CS_INCIDENT_SEVERITIES_TL SEVERITY,
6312: CS_INCIDENT_STATUSES_VL STATUS,
6313: --CS_INCIDENT_URGENCIES_VL URGENCY,
6314: CS_INCIDENT_URGENCIES_TL URGENCY,
6315: HZ_PARTIES RA2,
6316: CS_LOOKUPS CSLKUP,