337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,
344: igf_sl_cl_recipient recip
345: WHERE fabase.ci_cal_type = p_cal_type
424: FROM igf_ap_fa_base_rec fabase,
425: igf_sl_loans lar,
426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,
429: igf_aw_fund_cat fcat,
430: igf_sl_cl_recipient recip
431: WHERE lar.loan_id = lor.loan_id
432: AND lar.award_id = awd.award_id