DBA Data[Home] [Help]

APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on CS_INCIDENTS_B_SEC

Line 1187: FROM CS_INCIDENTS_B_SEC

1183: IF l_ws_code1 ='SR' THEN
1184: BEGIN
1185: SELECT INCIDENT_ID
1186: INTO l_sec_incident
1187: FROM CS_INCIDENTS_B_SEC
1188: WHERE incident_id = l_del_nw_item.WORKITEM_PK_ID;
1189: IF l_sec_incident IS NOT NULL THEN
1190: l_del_items_flag := 'Y';
1191: END IF;

Line 1201: FROM CS_INCIDENTS_B_SEC

1197: ELSIF l_ws_code1 ='SR_TASKS' THEN
1198: BEGIN
1199: SELECT INCIDENT_ID
1200: INTO l_sec_incident
1201: FROM CS_INCIDENTS_B_SEC
1202: WHERE incident_id = l_del_nw_item.SOURCE_OBJECT_ID;
1203: IF l_sec_incident IS NOT NULL THEN
1204: l_del_items_flag := 'Y';
1205: END IF;