APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_FUND_CAT_ALL

Line 404: igf_aw_fund_cat_all fcat

400: fcat.fed_fund_code,
401: fcat.fund_code
402: FROM igf_aw_award_all awd,
403: igf_aw_fund_mast_all fmast,
404: igf_aw_fund_cat_all fcat
405: WHERE awd.base_id = cp_base_id AND
406: awd.award_number_txt = cp_award_number AND
407: awd.fund_id = fmast.fund_id AND
408: fmast.fund_code = fcat.fund_code;

Line 1349: CURSOR c_get_fund_code ( cp_alt_loan_code igf_aw_fund_cat_all.alt_loan_code%TYPE,

1345:
1346: l_source_or_branch_id c_source_or_branch_id%ROWTYPE;
1347:
1348: -- FACR116
1349: CURSOR c_get_fund_code ( cp_alt_loan_code igf_aw_fund_cat_all.alt_loan_code%TYPE,
1350: cp_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE,
1351: cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE
1352: )
1353:

Line 1350: cp_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE,

1346: l_source_or_branch_id c_source_or_branch_id%ROWTYPE;
1347:
1348: -- FACR116
1349: CURSOR c_get_fund_code ( cp_alt_loan_code igf_aw_fund_cat_all.alt_loan_code%TYPE,
1350: cp_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE,
1351: cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE
1352: )
1353:
1354: IS

Line 1351: cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE

1347:
1348: -- FACR116
1349: CURSOR c_get_fund_code ( cp_alt_loan_code igf_aw_fund_cat_all.alt_loan_code%TYPE,
1350: cp_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE,
1351: cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE
1352: )
1353:
1354: IS
1355: SELECT fund_code

Line 1356: FROM igf_aw_fund_cat_all

1352: )
1353:
1354: IS
1355: SELECT fund_code
1356: FROM igf_aw_fund_cat_all
1357: WHERE NVL(alt_loan_code,'*') = cp_alt_loan_code
1358: AND NVL(alt_rel_code,'*') = cp_alt_rel_code
1359: AND fund_code = cp_fund_code;
1360: