DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 14056: cs_incident_statuses_b csb

14052: BEGIN
14053: SELECT 'x'
14054: INTO l_open_service
14055: FROM cs_incidents_all csi,
14056: cs_incident_statuses_b csb
14057: WHERE csi.incident_status_id = csb.incident_status_id
14058: AND csi.customer_product_id = p_instance_rec.instance_id
14059: AND NVL(close_flag,'N')<>'Y';
14060:

Line 20322: cs_incident_statuses_b csb

20318: BEGIN
20319: SELECT 'x'
20320: INTO l_open_service
20321: FROM cs_incidents_all csi,
20322: cs_incident_statuses_b csb
20323: WHERE csi.incident_status_id = csb.incident_status_id
20324: AND csi.customer_product_id = p_instance_rec.instance_id
20325: AND NVL(close_flag,'N')<>'Y';
20326: