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_CUST_LETTER_SET_LINES

Line 157: igi_dun_cust_letter_set_lines idclsl

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
161: AND idls.dunning_letter_set_id = idclsl.dunning_letter_set_id

Line 168: igi_dun_cust_letter_set_lines idclsl

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
172: AND idclsl.currency_code = hcpa.currency_code

Line 185: igi_dun_cust_letter_set_lines idclsl

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
189: AND idclsl.currency_code = hcpca.currency_code

Line 193: igi_dun_cust_letter_set_lines idclsl

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
197: AND idclsl.currency_code = hcpca.currency_code

Line 418: igi_dun_cust_letter_set_lines idclsl

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
422: AND hcpa.currency_code = r_aging_bkt_lines_site.ccy_code

Line 426: igi_dun_cust_letter_set_lines idclsl

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
430: AND hcpa.currency_code = r_aging_bkt_lines_site.ccy_code