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:
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
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