APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_DUNNING_LETTER_SETS

Line 7: FROM ar_dunning_letter_sets adls,

3:
4: CURSOR c_bkts IS
5: SELECT distinct adls.dunning_letter_set_id dls_id,
6: adls.name
7: FROM ar_dunning_letter_sets adls,
8: igi_dun_letter_sets idls
9: WHERE idls.dunning_letter_set_id = adls.dunning_letter_set_id
10: AND idls.use_dunning_flag = 'Y'
11: AND NOT EXISTS (SELECT 'Y'

Line 22: ar_dunning_letter_sets adls

18: adlsl.range_of_days_from,
19: adlsl.range_of_days_to
20: FROM ar_dunning_letter_set_lines adlsl,
21: igi_dun_letter_sets idls,
22: ar_dunning_letter_sets adls
23: WHERE adls.dunning_letter_set_id = p_dls_id
24: AND adls.dunning_letter_set_id = idls.dunning_letter_set_id
25: AND adlsl.dunning_letter_set_id = adls.dunning_letter_set_id;
26:

Line 33: ar_dunning_letter_sets adls,

29: adls.name,
30: idclsl.currency_code ccy_code,
31: idls.charge_per_invoice_flag charge_type
32: FROM igi_dun_cust_letter_set_lines idclsl,
33: ar_dunning_letter_sets adls,
34: igi_dun_letter_sets idls
35: WHERE decode(idls.charge_per_invoice_flag, 'Y', idclsl.invoice_charge_amount, 'N', idclsl.letter_charge_amount) IS NOT NULL
36: AND idclsl.dunning_letter_set_id = adls.dunning_letter_set_id
37: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id

Line 49: ar_dunning_letter_sets adls,

45: adls.name,
46: idlsl.currency_code ccy_code,
47: idls.charge_per_invoice_flag
48: FROM igi_dun_letter_set_lines idlsl,
49: ar_dunning_letter_sets adls,
50: igi_dun_letter_sets idls
51: WHERE decode(idls.charge_per_invoice_flag, 'Y', idlsl.invoice_charge_amount, 'N', idlsl.letter_charge_amount) IS NOT NULL
52: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
53: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id

Line 74: ar_dunning_letter_sets adls

70: idlsl.invoice_charge_amount,
71: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type
72: FROM ar_dunning_letter_set_lines adlsl,
73: igi_dun_letter_set_lines idlsl,
74: ar_dunning_letter_sets adls
75: WHERE adlsl.dunning_letter_set_id = idlsl.dunning_letter_set_id
76: AND adlsl.dunning_line_num = idlsl.dunning_line_num
77: AND adlsl.dunning_letter_id = idlsl.dunning_letter_id
78: AND adlsl.dunning_letter_set_id = adls.dunning_letter_set_id

Line 130: ar_dunning_letter_sets adls

126: idclsl.site_use_id,
127: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type
128: FROM ar_dunning_letter_set_lines adlsl,
129: igi_dun_cust_letter_set_lines idclsl,
130: ar_dunning_letter_sets adls
131: WHERE adlsl.dunning_letter_set_id = adls.dunning_letter_set_id
132: AND adlsl.dunning_letter_set_id = idclsl.dunning_letter_set_id
133: AND adlsl.dunning_line_num = idclsl.dunning_line_num
134: AND adlsl.dunning_letter_id = idclsl.dunning_letter_id

Line 146: ar_dunning_letter_sets adls,

142: adls.name,
143: idlsl.currency_code ccy_code,
144: charge_per_invoice_flag charge_type
145: FROM igi_dun_letter_set_lines idlsl,
146: ar_dunning_letter_sets adls,
147: igi_dun_letter_sets idls
148: WHERE decode(charge_per_invoice_flag, 'Y', letter_charge_amount, 'N', invoice_charge_amount) IS NOT NULL
149: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
150: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id

Line 163: ar_dunning_letter_sets adls,

159: adls.name,
160: idlsl.currency_code ccy_code,
161: charge_per_invoice_flag charge_type
162: FROM igi_dun_cust_letter_set_lines idlsl,
163: ar_dunning_letter_sets adls,
164: igi_dun_letter_sets idls
165: WHERE decode(charge_per_invoice_flag, 'Y', letter_charge_amount, 'N', invoice_charge_amount) IS NOT NULL
166: AND idlsl.dunning_letter_set_id = adls.dunning_letter_set_id
167: AND idls.dunning_letter_set_id = adls.dunning_letter_set_id