836: loan.*,
837: fcat.fed_fund_code
838: FROM igf_sl_loans_all loan,
839: igf_aw_award_all awd,
840: igf_aw_fund_mast_all fmast,
841: igf_aw_fund_cat_all fcat
842: WHERE
843: loan.award_id = awd.award_id AND
844: awd.fund_id = fmast.fund_id AND
856: WHERE (ci_cal_type,ci_sequence_number) = ( SELECT fmast.ci_cal_type,
857: fmast.ci_sequence_number
858: FROM igf_sl_loans loans,
859: igf_aw_award awd,
860: igf_aw_fund_mast fmast
861: WHERE loans.loan_number = p_loan_number
862: AND loans.award_id = awd.award_id
863: AND awd.fund_id = fmast.fund_id
864: );