APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_CHARGE_SCHEDULES

Line 40: FROM ar_charge_schedules acs

36: AND idclsl.dunning_letter_set_id = adls.dunning_letter_set_id
37: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id
38: AND idls.use_dunning_flag = 'Y'
39: AND NOT EXISTS (SELECT 'Y'
40: FROM ar_charge_schedules acs
41: WHERE acs.schedule_name = adls.name || '_' || idclsl.currency_code || '_' || idclsl.customer_profile_id);
42:
43: CURSOR c_aging_bkts IS
44: SELECT distinct adls.dunning_letter_set_id dls_id,

Line 56: FROM ar_charge_schedules acs

52: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
53: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id
54: AND idls.use_dunning_flag = 'Y'
55: AND NOT EXISTS (SELECT 'Y'
56: FROM ar_charge_schedules acs
57: WHERE acs.schedule_name = adls.name || '_' || idlsl.currency_code);
58:
59:
60: CURSOR c_aging_bkt_lines (p_dls_id VARCHAR2, p_ccy_code VARCHAR2) IS

Line 153: FROM ar_charge_schedules acs

149: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
150: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id
151: AND idls.use_dunning_flag = 'Y'
152: AND NOT EXISTS (SELECT 'Y'
153: FROM ar_charge_schedules acs
154: WHERE acs.schedule_name = adls.name || '_' || idlsl.currency_code || '_' || decode(idls.charge_per_invoice_flag, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'));
155:
156:
157: CURSOR c_aging_bkts_uu_site IS

Line 170: FROM ar_charge_schedules acs

166: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
167: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id
168: AND idls.use_dunning_flag = 'Y'
169: AND NOT EXISTS (SELECT 'Y'
170: FROM ar_charge_schedules acs
171: WHERE acs.schedule_name = adls.name || '_' || idlsl.currency_code || '_'|| idlsl.customer_profile_id || '_' || decode(idls.charge_per_invoice_flag, 'Y', 'PER_LETTER', 'N', 'PER_INVOICE'));
172:
173:
174: l_aging_bucket_line_id ar_aging_bucket_lines_b.aging_bucket_line_id%TYPE;

Line 177: l_schedule_id ar_charge_schedules.schedule_id%TYPE;

173:
174: l_aging_bucket_line_id ar_aging_bucket_lines_b.aging_bucket_line_id%TYPE;
175: l_schedule_header_id ar_charge_schedule_hdrs.schedule_id%TYPE;
176: l_aging_bucket_id ar_aging_buckets.aging_bucket_id%TYPE;
177: l_schedule_id ar_charge_schedules.schedule_id%TYPE;
178:
179:
180:
181: PROCEDURE DUNNING_UPG(ERRBUF OUT NOCOPY VARCHAR2,