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

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

537: and the Cursor c_fadv to point to the table
538: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
539:
540: || vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which
541: || is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual.
542: || The datatype for v_total_payments variable is also changed to NUMBER after removing
543: || the reference to igs_fi_fee_pay_v.
544: ----------------------------------------------------------------------------*/
545:

Line 568: FROM dual;

564: AND fadv.logical_delete_dt IS NULL;
565:
566: CURSOR c_fpv IS
567: SELECT 0
568: FROM dual;
569:
570: /* CURSOR c_fpv IS
571: SELECT SUM(fpv.payment_amount)
572: FROM IGS_FI_FEE_PAY_V fpv