APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 823: FROM CS_INCIDENT_STATUSES_VL

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

Line 1498: cs_incident_statuses_vl b

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

Line 5055: FROM CS_INCIDENT_STATUSES_VL

5051: END IF;
5052:
5053: SELECT name
5054: INTO l_request_status_temp
5055: FROM CS_INCIDENT_STATUSES_VL
5056: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
5057:
5058: IF (l_request_status = l_request_status_temp) THEN
5059: WF_ENGINE.SetItemAttrNumber(

Line 6248: CS_INCIDENT_STATUSES_VL STATUS,

6244: --CS_INCIDENT_TYPES_VL TYPE,
6245: CS_INCIDENT_TYPES_TL TYPE,
6246: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
6247: CS_INCIDENT_SEVERITIES_TL SEVERITY,
6248: CS_INCIDENT_STATUSES_VL STATUS,
6249: --CS_INCIDENT_URGENCIES_VL URGENCY,
6250: CS_INCIDENT_URGENCIES_TL URGENCY,
6251: HZ_PARTIES RA2,
6252: CS_LOOKUPS CSLKUP,