APPS.CSD_REPAIRS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1451: FROM cs_incidents_all_b sr

1447: IS
1448:
1449: CURSOR c1 IS
1450: SELECT 'X'
1451: FROM cs_incidents_all_b sr
1452: WHERE sr.incident_id = p_incident_id; -- need to add more condition
1453:
1454: l_dummy VARCHAR2(1);
1455: l_valid VARCHAR2(1) := 'Y';

Line 1564: cs_incidents_all_b sr

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
1568: AND sr.customer_id = cii.owner_party_id

Line 1576: FROM cs_incidents_all_b sr,

1572: l_valid VARCHAR2(1) := 'Y';
1573: */
1574: CURSOR c1 IS
1575: SELECT 'X'
1576: FROM cs_incidents_all_b sr,
1577: csi_i_parties cip
1578: WHERE sr.incident_id = p_incident_id
1579: AND cip.instance_id = p_customer_product_id
1580: AND sr.customer_id = cip.party_id

Line 1641: cs_incidents_all_b sr

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
1645: AND cii.owner_party_id IN (sr.customer_id , l_Internal_Party_Id )