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_SL_DL_ORIG dependencies on IGF_SL_LOANS_ALL

Line 8: p_loan_number igf_sl_loans_all.loan_number%TYPE,

4: PROCEDURE dl_originate(errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_award_year VARCHAR2,
7: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
8: p_loan_number igf_sl_loans_all.loan_number%TYPE,
9: p_org_id IN NUMBER,
10: school_type IN VARCHAR2,
11: p_school_code IN VARCHAR2)
12: AS

Line 212: FROM igf_sl_loans_all loan,

208:
209:
210: CURSOR c_loans IS
211: SELECT loan.loan_id
212: FROM igf_sl_loans_all loan,
213: igf_aw_award_all awd,
214: igf_aw_fund_mast_all fmast,
215: igf_aw_fund_cat_all fcat
216: WHERE

Line 585: FROM igf_sl_loans_all loans,

581: lor.b_alien_reg_num_txt,
582: lor.esign_src_typ_cd,
583: lor.acad_begin_date,
584: lor.acad_end_date
585: FROM igf_sl_loans_all loans,
586: igf_sl_lor_all lor,
587: igf_aw_award_all awd,
588: igf_ap_fa_base_rec_all fabase,
589: igf_aw_fund_mast_all fmast