59: -- bkkumar 16-oct-03 Bug 3104228 FA 122 Build Passed the correct token to
60: -- "award_year" to the fnd_message.
61: ----------------------------------------------------------------------------------
62: -- sjadhav 8-Oct-2003 Bug 3104228 FA 122 Build
63: -- use recipient info from igf_sl_lor_v to
64: -- insert into igf_sl_Lor_loc table
65: ---------------------------------------------------------------------------------
66: -- bkkumar 06-oct-2003 Bug 3104228 FA 122 Loans Enhancements
67: -- a) Impact of obsoleting GUARANTOR_ID_TXT,
3648: lor.recip_non_ed_brc_id,
3649: lor.recipient_type,
3650: fabase.person_id student_id
3651: FROM igf_sl_loans loans,
3652: igf_sl_lor_v lor,
3653: igf_aw_award awd,
3654: igf_ap_fa_base_rec fabase
3655: WHERE fabase.base_id = awd.base_id
3656: AND loans.award_id = awd.award_id