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.IGS_FI_PRC_HOLDS dependencies on IGS_FI_INV_INT_ALL

Line 260: FROM igs_fi_inv_int_all chg,

256: -- Cursor to calculate the total charge amount waived when a plan level is "Balance"
257: -- Added as part of Bug# 3192641
258: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS
259: SELECT NVL(SUM(chg.invoice_amount), 0)
260: FROM igs_fi_inv_int_all chg,
261: igs_fi_inv_wav_det wav
262: WHERE person_id = cp_n_person_id
263: AND chg.invoice_id = wav.invoice_id
264: AND wav.balance_type = 'HOLDS'

Line 1788: FROM igs_fi_inv_int_all chg,

1784: -- Cursor to get the total amount of waived charges
1785: -- Added as part of Bug# 3192641
1786: CURSOR c_waive_amount( cp_n_person_id NUMBER, cp_d_process_start_date DATE) IS
1787: SELECT NVL(SUM(chg.invoice_amount), 0)
1788: FROM igs_fi_inv_int_all chg,
1789: igs_fi_inv_wav_det wav
1790: WHERE person_id = cp_n_person_id
1791: AND chg.invoice_id = wav.invoice_id
1792: AND wav.balance_type = 'HOLDS'