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.IGF_DB_DL_DISB_ORIG dependencies on IGF_SL_LOANS

Line 115: igf_sl_loans lar,

111: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
112: SELECT '1'
113: FROM igf_aw_db_chg_dtls adtlv,
114: igf_aw_award awd,
115: igf_sl_loans lar,
116: igf_ap_fa_base_rec fabase
117: WHERE -- ## Pick up all records with SF Status 1)"to be Posted" and Pick up Disbursements with Future dates and within 7 Future days,
118: -- "Posted" to Student Account.
119: adtlv.disb_date-TRUNC(SYSDATE) <=7

Line 350: igf_sl_loans lar,

346: CURSOR cur_disb_dtl IS
347: SELECT adtlv.*, fabase.base_id, lar.loan_number
348: FROM igf_aw_db_chg_dtls adtlv,
349: igf_aw_award awd,
350: igf_sl_loans lar,
351: igf_ap_fa_base_rec fabase
352: WHERE
353: adtlv.disb_date-TRUNC(SYSDATE) <=7
354: AND adtlv.disb_status = 'G' -- ## With Disbursement Status as Ready to Send