eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_LETTER_SETS

Line 8: igi_dun_letter_sets idls

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'
12: FROM ar_aging_buckets aab

Line 21: igi_dun_letter_sets idls,

17: adlsl.dunning_line_num,
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;

Line 34: igi_dun_letter_sets idls

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
38: AND idls.use_dunning_flag = 'Y'

Line 50: igi_dun_letter_sets idls

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
54: AND idls.use_dunning_flag = 'Y'

Line 71: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type

67: adlsl.range_of_days_to,
68: idlsl.currency_code ccy_code,
69: idlsl.letter_charge_amount,
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

Line 88: FROM igi_dun_letter_set_lines idlsl, igi_dun_cust_letter_set_lines idclsl, igi_dun_letter_sets idls

84: /*Added for creating Charge Schedules where charge amounts were changed at customer level - mbremkum*/
85:
86: CURSOR c_override_dunning_letter (p_dls_id VARCHAR2, p_ccy_code VARCHAR2, p_charge_type VARCHAR2) IS
87: SELECT idlsl.dunning_letter_set_id dls_id, idlsl.currency_code ccy_code, idclsl.customer_profile_id
88: FROM igi_dun_letter_set_lines idlsl, igi_dun_cust_letter_set_lines idclsl, igi_dun_letter_sets idls
89: WHERE decode(p_charge_type, 'N', (nvl(idclsl.letter_charge_amount, -99) - nvl(idlsl.letter_charge_amount,-99)),
90: 'Y', (nvl(idclsl.invoice_charge_amount,-99) - nvl(idlsl.invoice_charge_amount,-99))) <> 0
91: AND idls.dunning_letter_set_id = idlsl.dunning_letter_set_id
92: AND idls.use_dunning_flag = 'Y'

Line 102: FROM igi_dun_letter_set_lines idlsl, igi_dun_cust_letter_set_lines idclsl, igi_dun_letter_sets idls

98: AND idclsl.dunning_line_num = idlsl.dunning_line_num;
99:
100: CURSOR c_override_dunning_letter_uu (p_dls_id VARCHAR2, p_ccy_code VARCHAR2, p_charge_type VARCHAR2) IS
101: SELECT idlsl.dunning_letter_set_id dls_id, idlsl.currency_code ccy_code, idclsl.customer_profile_id
102: FROM igi_dun_letter_set_lines idlsl, igi_dun_cust_letter_set_lines idclsl, igi_dun_letter_sets idls
103: WHERE decode(p_charge_type, 'Y', (nvl(idclsl.letter_charge_amount, -99) - nvl(idlsl.letter_charge_amount,-99)),
104: 'N', (nvl(idclsl.invoice_charge_amount,-99) - nvl(idlsl.invoice_charge_amount,-99))) <> 0
105: AND idls.dunning_letter_set_id = idlsl.dunning_letter_set_id
106: AND idlsl.dunning_letter_set_id = idclsl.dunning_letter_set_id

Line 127: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type

123: idclsl.invoice_charge_amount,
124: idclsl.customer_profile_id,
125: idclsl.customer_profile_class_id,
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

Line 147: igi_dun_letter_sets idls

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
151: AND idls.use_dunning_flag = 'Y'

Line 164: igi_dun_letter_sets idls

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
168: AND idls.use_dunning_flag = 'Y'