DBA Data[Home] [Help]

APPS.CS_CHARGE_CORE_PVT dependencies on CS_INCIDENTS_ALL_B

Line 25: FROM CS_INCIDENTS_ALL_B

21: IF p_source_code = 'SR' THEN
22:
23: IF p_source_number IS NOT NULL THEN
24: SELECT incident_id INTO x_source_id
25: FROM CS_INCIDENTS_ALL_B
26: WHERE incident_number = p_source_number;
27: ELSE
28: p_return_status := 'F' ;
29:

Line 273: FROM CS_INCIDENTS_ALL_B

269: l_ship_site_use_id NUMBER;
270:
271: CURSOR c_cust_id IS
272: SELECT account_id
273: FROM CS_INCIDENTS_ALL_B
274: WHERE incident_id = p_qte_header_id;
275:
276: CURSOR C_site_use(l_cust_id NUMBER, l_ship_site_id NUMBER) IS
277: SELECT site_use_id

Line 357: FROM CS_INCIDENTS_ALL_B

353: l_bill_site_use_id NUMBER;
354:
355: CURSOR c_cust_id IS
356: SELECT customer_id
357: FROM CS_INCIDENTS_ALL_B
358: WHERE incident_id = p_qte_header_id;
359:
360: CURSOR C_site_use(l_cust_id NUMBER, l_inv_site_id NUMBER) IS
361: SELECT site_use_id