APPS.CSD_REPAIRS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1563: FROM csi_item_instances cii,

1559: IS
1560: /* Bug fix 9225852: Commented out old definition of cursor c1 and replaced with new one
1561: CURSOR c1 IS
1562: SELECT 'X'
1563: FROM csi_item_instances cii,
1564: cs_incidents_all_b sr
1565: WHERE sr.incident_id = p_incident_id
1566: AND cii.instance_id = p_customer_product_id
1567: AND cii.inventory_item_id = p_inventory_item_id

Line 1640: FROM csi_item_instances cii,

1636: l_Internal_Party_Id NUMBER ;
1637:
1638: CURSOR c1 IS
1639: SELECT 'X'
1640: FROM csi_item_instances cii,
1641: cs_incidents_all_b sr
1642: WHERE sr.incident_id = p_incident_id
1643: AND cii.instance_id = p_customer_product_id
1644: AND cii.inventory_item_id = p_inventory_item_id