DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CS_INCIDENTS_ALL

Line 14447: FROM cs_incidents_all csi,

14443: THEN
14444: BEGIN
14445: SELECT 'x'
14446: INTO l_open_service
14447: FROM cs_incidents_all csi,
14448: cs_incident_statuses_b csb
14449: WHERE csi.incident_status_id = csb.incident_status_id
14450: AND csi.customer_product_id = p_instance_rec.instance_id
14451: AND NVL(close_flag,'N')<>'Y';

Line 20857: FROM cs_incidents_all csi,

20853: THEN
20854: BEGIN
20855: SELECT 'x'
20856: INTO l_open_service
20857: FROM cs_incidents_all csi,
20858: cs_incident_statuses_b csb
20859: WHERE csi.incident_status_id = csb.incident_status_id
20860: AND csi.customer_product_id = p_instance_rec.instance_id
20861: AND NVL(close_flag,'N')<>'Y';