APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_CUST_LETTER_SET_LINES

Line 32: FROM igi_dun_cust_letter_set_lines idclsl,

28: SELECT distinct adls.dunning_letter_set_id dls_id,
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

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 129: igi_dun_cust_letter_set_lines idclsl,

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
132: AND adlsl.dunning_letter_set_id = idclsl.dunning_letter_set_id
133: AND adlsl.dunning_line_num = idclsl.dunning_line_num

Line 162: FROM igi_dun_cust_letter_set_lines idlsl,

158: SELECT distinct adls.dunning_letter_set_id dls_id,
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