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_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_APPL_ALL

Line 593: modified to derive fee amount from igs_ad_appl_all - igsm - arvsrini

589: x_msg_data OUT NOCOPY VARCHAR2)
590: AS
591: /**************************************************************
592: Created By :rboddu
593: modified to derive fee amount from igs_ad_appl_all - igsm - arvsrini
594: Date Created By : 31-DEC-2001
595: Purpose : 2158524
596: Know limitations, enhancements or remarks
597: Change History

Line 625: IGS_AD_APPL_ALL apl,

621: CURSOR c_appl_fee_amt IS
622: SELECT
623: (NVL(apl.appl_fee_amt,0)-sum(req.FEE_AMOUNT)) OutstandingBal
624: FROM
625: IGS_AD_APPL_ALL apl,
626: igs_ad_app_req req
627: WHERE
628: apl.person_id= p_person_id AND
629: apl.admission_appl_number = p_admission_appl_number AND

Line 643: FROM IGS_AD_APPL_ALL apl

639: --cursor to fetch the initial application fee amount
640: CURSOR c_appl_fee_appl IS
641: SELECT
642: NVL(apl.appl_fee_amt,0) appfee
643: FROM IGS_AD_APPL_ALL apl
644: WHERE
645: apl.person_id= p_person_id AND
646: apl.admission_appl_number = p_admission_appl_number;
647: