APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_FUND_CAT

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:

Line 5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;

5083:
5084: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
5086: l_award_id igf_aw_award_all.award_id%TYPE;
5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;
5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;
5089: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
5090:
5091: l_interface c_interface%ROWTYPE;