APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_AGING_BUCKET_LINES_B

Line 76: INSERT INTO ar_aging_bucket_lines_b

72: RETURNING aging_bucket_id INTO l_aging_bucket_id;
73:
74: FOR r_bkts_lines IN c_bkts_lines(r_bkts.dls_id) LOOP
75:
76: INSERT INTO ar_aging_bucket_lines_b
77: (
78: aging_bucket_line_id,
79: aging_bucket_id,
80: bucket_sequence_num,

Line 254: FROM ar_aging_bucket_lines_b

250:
251: FOR r_aging_bkt_lines IN c_aging_bkt_lines(r_aging_bkts.dls_id, r_aging_bkts.ccy_code) LOOP
252:
253: SELECT aging_bucket_line_id INTO l_aging_bucket_line_id
254: FROM ar_aging_bucket_lines_b
255: WHERE aging_bucket_id = l_aging_bucket_id
256: AND bucket_sequence_num = r_aging_bkt_lines.dunning_line_num
257: AND days_start = r_aging_bkt_lines.range_of_days_from
258: AND days_to = r_aging_bkt_lines.range_of_days_to;

Line 265: --dbms_output.put_line('Inserted Rows in ar_aging_bucket_lines_b : '|| SQL%ROWCOUNT);

261: Put_Debug_Msg(l_full_path, 'Aging Bucket Line ID: ' || l_aging_bucket_line_id);
262: END IF;
263:
264:
265: --dbms_output.put_line('Inserted Rows in ar_aging_bucket_lines_b : '|| SQL%ROWCOUNT);
266:
267: INSERT INTO ar_charge_schedule_lines
268: (
269: schedule_line_id,

Line 484: FROM ar_aging_bucket_lines_b

480: Put_Debug_Msg(l_full_path, 'Range of days to(Site Override): ' || r_aging_bkt_lines_site.range_of_days_to);
481: END IF;
482:
483: SELECT aging_bucket_line_id INTO l_aging_bucket_line_id
484: FROM ar_aging_bucket_lines_b
485: WHERE aging_bucket_id = l_aging_bucket_id
486: AND bucket_sequence_num = r_aging_bkt_lines_site.dunning_line_num
487: AND days_start = r_aging_bkt_lines_site.range_of_days_from
488: AND days_to = r_aging_bkt_lines_site.range_of_days_to;

Line 626: FROM ar_aging_bucket_lines_b

622:
623: FOR r_aging_bkt_lines IN c_aging_bkt_lines(r_aging_bkts_uu.dls_id, r_aging_bkts_uu.ccy_code) LOOP
624:
625: SELECT aging_bucket_line_id INTO l_aging_bucket_line_id
626: FROM ar_aging_bucket_lines_b
627: WHERE aging_bucket_id = l_aging_bucket_id
628: AND bucket_sequence_num = r_aging_bkt_lines.dunning_line_num
629: AND days_start = r_aging_bkt_lines.range_of_days_from
630: AND days_to = r_aging_bkt_lines.range_of_days_to;

Line 828: FROM ar_aging_bucket_lines_b

824: Put_Debug_Msg(l_full_path, 'Range of days to(Site Override - Un Used): ' || r_aging_bkt_lines_site.range_of_days_to);
825: END IF;
826:
827: SELECT aging_bucket_line_id INTO l_aging_bucket_line_id
828: FROM ar_aging_bucket_lines_b
829: WHERE aging_bucket_id = l_aging_bucket_id
830: AND bucket_sequence_num = r_aging_bkt_lines_site.dunning_line_num
831: AND days_start = r_aging_bkt_lines_site.range_of_days_from
832: AND days_to = r_aging_bkt_lines_site.range_of_days_to;