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 156: FROM igi_dun_letter_sets idls,

152: /*Schedule ID is always populated if interest_type is
153: 'CHARGES_SCHEDULE' or 'CHARGE_PER_TIER' - mbremkum*/
154: l_schedule_id,
155: -1, SYSDATE
156: FROM igi_dun_letter_sets idls,
157: igi_dun_cust_letter_set_lines idclsl
158: /*Added the below condition so that update is based on
159: dunning_letter_set_id from the cursor - mbremkum*/
160: WHERE idls.dunning_letter_set_id = r_aging_bkts.dls_id

Line 167: FROM igi_dun_letter_sets idls,

163: AND idclsl.currency_code = hcpa.currency_code
164: AND hcpa.currency_code = r_aging_bkts.ccy_code
165: AND NVL(idclsl.site_use_id,-99)= NVL(hcpa.site_use_id, -99))
166: WHERE EXISTS (SELECT 'Y'
167: FROM igi_dun_letter_sets idls,
168: igi_dun_cust_letter_set_lines idclsl
169: WHERE idls.dunning_letter_set_id = r_aging_bkts.dls_id
170: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id
171: AND idclsl.customer_profile_id = hcpa.cust_account_profile_id

Line 184: FROM igi_dun_letter_sets idls,

180: last_updated_by, last_update_date) =
181: (SELECT distinct DECODE(idls.charge_per_invoice_flag, 'Y', 'CHARGES_SCHEDULE', 'N', 'CHARGE_PER_TIER'),
182: l_schedule_id,
183: -1, SYSDATE
184: FROM igi_dun_letter_sets idls,
185: igi_dun_cust_letter_set_lines idclsl
186: WHERE idls.dunning_letter_set_id = r_aging_bkts.dls_id
187: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id
188: AND idclsl.customer_profile_class_id = hcpca.profile_class_id

Line 192: FROM igi_dun_letter_sets idls,

188: AND idclsl.customer_profile_class_id = hcpca.profile_class_id
189: AND idclsl.currency_code = hcpca.currency_code
190: AND hcpca.currency_code = r_aging_bkts.ccy_code)
191: WHERE EXISTS (SELECT 'Y'
192: FROM igi_dun_letter_sets idls,
193: igi_dun_cust_letter_set_lines idclsl
194: WHERE idls.dunning_letter_set_id = r_aging_bkts.dls_id
195: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id
196: AND idclsl.customer_profile_class_id = hcpca.profile_class_id

Line 349: igi_dun_letter_sets idls

345: adls.name,
346: idlsc.currency_code INTO l_dls_id, l_name, l_ccy_code
347: FROM igi_dun_letter_set_cur idlsc,
348: ar_dunning_letter_sets adls,
349: igi_dun_letter_sets idls
350: WHERE adls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
351: AND idlsc.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
352: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
353: AND idlsc.currency_code = r_aging_bkt_lines_site.ccy_code

Line 417: FROM igi_dun_letter_sets idls,

413: SET (interest_type, interest_schedule_id,
414: last_updated_by, last_update_date) =
415: (SELECT distinct DECODE(idls.charge_per_invoice_flag, 'Y', 'CHARGES_SCHEDULE', 'N', 'CHARGE_PER_TIER'),
416: l_schedule_id,-1, SYSDATE
417: FROM igi_dun_letter_sets idls,
418: igi_dun_cust_letter_set_lines idclsl
419: WHERE idls.dunning_letter_set_id = l_dls_id
420: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id
421: AND hcpa.cust_account_profile_id = r_aging_bkt_lines_site.customer_profile_id

Line 425: FROM igi_dun_letter_sets idls,

421: AND hcpa.cust_account_profile_id = r_aging_bkt_lines_site.customer_profile_id
422: AND hcpa.currency_code = r_aging_bkt_lines_site.ccy_code
423: AND NVL(hcpa.site_use_id, -99) = NVL(r_aging_bkt_lines_site.site_use_id, -99))
424: WHERE EXISTS (SELECT 'Y'
425: FROM igi_dun_letter_sets idls,
426: igi_dun_cust_letter_set_lines idclsl
427: WHERE idls.dunning_letter_set_id = l_dls_id
428: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id
429: AND hcpa.cust_account_profile_id = r_aging_bkt_lines_site.customer_profile_id

Line 711: igi_dun_letter_sets idls

707: adls.name,
708: idlsc.currency_code INTO l_dls_id, l_name, l_ccy_code
709: FROM igi_dun_letter_set_cur idlsc,
710: ar_dunning_letter_sets adls,
711: igi_dun_letter_sets idls
712: WHERE adls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
713: AND idlsc.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
714: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
715: AND idlsc.currency_code = r_aging_bkt_lines_site.ccy_code