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_HE_EXTRACT_FIELDS_PKG dependencies on IGS_FI_FEE_AS

Line 3546: view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as. This is done

3542: Change History :
3543: Who When What
3544: smaddali Modified this procedure for bug 2716038
3545: dsridhar 10-Sep-03 Bug No: 2911678. Modified the cursor c_fees by replacing the
3546: view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as. This is done
3547: as the view igs_fi_fee_ass_debt_v has performance issues and is being
3548: obsoleted.
3549: smaddali 13-Oct-03 Modified procedure to add 2 new parameters and modified cursor c_fees for bug# 3179544
3550: jtmathew 04-Jul-06 Modifications for bug 5283519. Modified procedure to run for all students,

Line 3547: as the view igs_fi_fee_ass_debt_v has performance issues and is being

3543: Who When What
3544: smaddali Modified this procedure for bug 2716038
3545: dsridhar 10-Sep-03 Bug No: 2911678. Modified the cursor c_fees by replacing the
3546: view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as. This is done
3547: as the view igs_fi_fee_ass_debt_v has performance issues and is being
3548: obsoleted.
3549: smaddali 13-Oct-03 Modified procedure to add 2 new parameters and modified cursor c_fees for bug# 3179544
3550: jtmathew 04-Jul-06 Modifications for bug 5283519. Modified procedure to run for all students,
3551: and also sets tuition fees to zero if c_fees returns NULL

Line 3556: -- Bug No: 2911678. Replacing the view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as.

3552: ***************************************************************/
3553:
3554: -- smaddali modified this cursor to remove the obsoleted table igs_fi_chg_mth_app reference
3555: -- as part of bug 2421778
3556: -- Bug No: 2911678. Replacing the view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as.
3557: -- smaddali modified this cursor for bug#3179544 , filtering based on Submission periods
3558: CURSOR c_fees IS
3559: SELECT SUM(chg.transaction_amount) tuition_fees
3560: FROM igs_fi_fee_type ft, igs_fi_fee_as chg

Line 3560: FROM igs_fi_fee_type ft, igs_fi_fee_as chg

3556: -- Bug No: 2911678. Replacing the view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as.
3557: -- smaddali modified this cursor for bug#3179544 , filtering based on Submission periods
3558: CURSOR c_fees IS
3559: SELECT SUM(chg.transaction_amount) tuition_fees
3560: FROM igs_fi_fee_type ft, igs_fi_fee_as chg
3561: WHERE ft.s_fee_type = 'TUTNFEE'
3562: AND chg.person_id = p_person_id
3563: AND (chg.course_cd IS NULL OR chg.course_cd = p_course_cd)
3564: AND chg.fee_type = ft.fee_type