APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_LETTER_SET_LINES

Line 48: FROM igi_dun_letter_set_lines idlsl,

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

Line 73: igi_dun_letter_set_lines idlsl,

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
76: AND adlsl.dunning_line_num = idlsl.dunning_line_num
77: AND adlsl.dunning_letter_id = idlsl.dunning_letter_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 145: FROM igi_dun_letter_set_lines idlsl,

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