DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 14448: cs_incident_statuses_b csb

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';
14452:

Line 20858: cs_incident_statuses_b csb

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';
20862: