APPS.IGIGITCH dependencies on IGI_ITR_CHARGE_LINES

Line 12: FROM igi_itr_charge_lines

8: BEGIN
9: -- get total number of services associated with the cross charge
10: SELECT count(*)
11: INTO l_total_recs
12: FROM igi_itr_charge_lines
13: WHERE it_header_id = p_it_header_id;
14:
15: -- get total number of services that are either in canceled L or
16: -- approved A status

Line 19: FROM igi_itr_charge_lines

15: -- get total number of services that are either in canceled L or
16: -- approved A status
17: SELECT count(*)
18: INTO l_total_status
19: FROM igi_itr_charge_lines
20: WHERE it_header_id = p_it_header_id
21: AND status_flag IN ('L', 'A');
22:
23: -- if all the services are either cancelled or approved then update