APPS.CSD_PROCESS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 2400: FROM cs_incidents_all_b

2396: --]
2397:
2398: CURSOR order_rec(p_incident_id IN NUMBER) IS
2399: SELECT customer_id, account_id
2400: FROM cs_incidents_all_b
2401: WHERE incident_id = p_incident_id;
2402:
2403: CURSOR estimate(p_rep_line_id IN NUMBER) IS
2404: SELECT estimate_detail_id, object_version_number

Line 2427: FROM cs_incidents_all_b cs, csd_repairs csd

2423:
2424: -- swai: bug 6001057
2425: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2426: SELECT account_id
2427: FROM cs_incidents_all_b cs, csd_repairs csd
2428: WHERE cs.incident_id = csd.incident_id
2429: AND repair_line_id = l_repair_line_id;
2430:
2431: --R12 Development Changes Begin

Line 2460: cs_incidents_all_b cs

2456: from hz_party_sites_v hp,
2457: hz_parties hz,
2458: hz_cust_acct_sites_all hca,
2459: hz_cust_site_uses_all hcsu,
2460: cs_incidents_all_b cs
2461: where hcsu.site_use_code = p_site_use_type
2462: and cs.incident_id = p_incident_id
2463: and hp.status = 'A'
2464: and hcsu.status = 'A'

Line 4166: FROM cs_incidents_all_b

4162: ship_order EXCEPTION;
4163:
4164: CURSOR get_account_details(p_incident_id IN NUMBER) IS
4165: SELECT customer_id, account_id
4166: FROM cs_incidents_all_b
4167: WHERE incident_id = p_incident_id;
4168:
4169: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4170: SELECT estimate_detail_id, object_version_number

Line 7658: FROM cs_incidents_all_b

7654:
7655: BEGIN
7656: SELECT object_version_number
7657: INTO l_inc_obj_version_number
7658: FROM cs_incidents_all_b
7659: WHERE incident_id = p_incident_id;
7660: EXCEPTION
7661: WHEN OTHERS THEN
7662: l_inc_obj_version_number := -1;

Line 7894: FROM cs_incidents_all_b

7890:
7891: BEGIN
7892: SELECT object_version_number
7893: INTO l_inc_obj_version_number
7894: FROM cs_incidents_all_b
7895: WHERE incident_id = l_incident_id;
7896: EXCEPTION
7897: WHEN OTHERS THEN
7898: l_inc_obj_version_number := -1;

Line 8269: FROM cs_incidents_all_b

8265: ship_order_excep EXCEPTION;
8266:
8267: CURSOR sr_rec(p_incident_id IN NUMBER) IS
8268: SELECT customer_id, account_id
8269: FROM cs_incidents_all_b
8270: WHERE incident_id = p_incident_id;
8271:
8272: CURSOR prod_txn(p_prod_txn_id IN NUMBER) IS
8273: SELECT estimate_detail_id,