[Home] [Help]
1116: FUNCTION get_fund_desc(p_fund_id IN NUMBER)
1117: RETURN VARCHAR2 IS
1118: CURSOR cur_get_fund_desc (p_fund_id NUMBER)
1119: IS
1120: SELECT description FROM igf_aw_fund_mast_all
1121: WHERE fund_id = p_fund_id;
1122:
1123: get_fund_desc_rec cur_get_fund_desc%ROWTYPE;
1124:
1376: FROM
1377: igf_sl_lor_all lor,
1378: igf_sl_loans_all loan,
1379: igf_aw_award_all awd,
1380: igf_aw_fund_mast_all fmast
1381: WHERE
1382: loan.award_id = awd.award_id AND
1383: awd.fund_id = fmast.fund_id AND
1384: fmast.ci_sequence_number = p_seq_number AND
1399: FROM
1400: igf_sl_lor_all lor,
1401: igf_sl_loans_all loan,
1402: igf_aw_award_all awd,
1403: igf_aw_fund_mast_all fmast
1404: WHERE
1405: loan.award_id = awd.award_id AND
1406: awd.fund_id = fmast.fund_id AND
1407: fmast.ci_sequence_number = p_seq_number AND