DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1425: FROM cs_incidents_all_b

1421: l_item_cost NUMBER := NULL;
1422:
1423: CURSOR order_rec(p_incident_id IN NUMBER) IS
1424: SELECT customer_id, account_id
1425: FROM cs_incidents_all_b
1426: WHERE incident_id = p_incident_id;
1427:
1428: BEGIN
1429: -- Standard Start of API savepoint

Line 2989: FROM cs_incidents_all_b cia, CSD_REPAIRS cr

2985:
2986: BEGIN
2987: SELECT cia.incident_id, cia.customer_id, cia.account_id
2988: INTO l_incident_id, l_party_id, l_account_id
2989: FROM cs_incidents_all_b cia, CSD_REPAIRS cr
2990: WHERE cia.incident_id = cr.incident_id
2991: AND cr.repair_line_id = p_repair_line_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN