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_GEN_006 dependencies on DUAL

Line 130: || is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual. This

126: || (reverse chronological order - newest change first)
127: uudayapr 12-12-2003 bug#3080983 made the modification to Cursor c_fadv to point to the table
128: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
129: || vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which
130: || is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual. This
131: || function will be obsoleted as part of HECS functionality obsoletion. As this got
132: || deferred for Jan'03 scope,commented out this portion.
133: || vvutukur 30-Aug-2002 Bug#2531390.Removed default value of p_update_ind parameter to avoid
134: || gscc warning.

Line 191: FROM dual;

187: HAVING SUM(fadv.transaction_amount) >0;
188:
189: CURSOR c_fpv IS
190: SELECT 0
191: FROM dual;
192:
193: /* CURSOR c_fpv IS
194: SELECT SUM(fpv.payment_amount)
195: FROM IGS_FI_FEE_PAY_V fpv,