APPS.CSD_PROCESS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 2317: FROM cs_incidents_all_b

2313: --]
2314:
2315: CURSOR order_rec(p_incident_id IN NUMBER) IS
2316: SELECT customer_id, account_id
2317: FROM cs_incidents_all_b
2318: WHERE incident_id = p_incident_id;
2319:
2320: CURSOR estimate(p_rep_line_id IN NUMBER) IS
2321: SELECT estimate_detail_id, object_version_number

Line 2344: FROM cs_incidents_all_b cs, csd_repairs csd

2340:
2341: -- swai: bug 6001057
2342: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2343: SELECT account_id
2344: FROM cs_incidents_all_b cs, csd_repairs csd
2345: WHERE cs.incident_id = csd.incident_id
2346: AND repair_line_id = l_repair_line_id;
2347:
2348: --R12 Development Changes Begin

Line 2377: cs_incidents_all_b cs

2373: from hz_party_sites_v hp,
2374: hz_parties hz,
2375: hz_cust_acct_sites_all hca,
2376: hz_cust_site_uses_all hcsu,
2377: cs_incidents_all_b cs
2378: where hcsu.site_use_code = p_site_use_type
2379: and cs.incident_id = p_incident_id
2380: and hp.status = 'A'
2381: and hcsu.status = 'A'

Line 4070: FROM cs_incidents_all_b

4066: ship_order EXCEPTION;
4067:
4068: CURSOR get_account_details(p_incident_id IN NUMBER) IS
4069: SELECT customer_id, account_id
4070: FROM cs_incidents_all_b
4071: WHERE incident_id = p_incident_id;
4072:
4073: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4074: SELECT estimate_detail_id, object_version_number

Line 7503: FROM cs_incidents_all_b

7499:
7500: BEGIN
7501: SELECT object_version_number
7502: INTO l_inc_obj_version_number
7503: FROM cs_incidents_all_b
7504: WHERE incident_id = p_incident_id;
7505: EXCEPTION
7506: WHEN OTHERS THEN
7507: l_inc_obj_version_number := -1;

Line 7739: FROM cs_incidents_all_b

7735:
7736: BEGIN
7737: SELECT object_version_number
7738: INTO l_inc_obj_version_number
7739: FROM cs_incidents_all_b
7740: WHERE incident_id = l_incident_id;
7741: EXCEPTION
7742: WHEN OTHERS THEN
7743: l_inc_obj_version_number := -1;

Line 8114: FROM cs_incidents_all_b

8110: ship_order_excep EXCEPTION;
8111:
8112: CURSOR sr_rec(p_incident_id IN NUMBER) IS
8113: SELECT customer_id, account_id
8114: FROM cs_incidents_all_b
8115: WHERE incident_id = p_incident_id;
8116:
8117: CURSOR prod_txn(p_prod_txn_id IN NUMBER) IS
8118: SELECT estimate_detail_id,