APPS.IGF_SL_AWARD dependencies on IGF_AW_FUND_MAST

Line 89: igf_aw_fund_mast fundmast,

85: )
86: IS
87: SELECT fed_fund_code
88: FROM igf_aw_award awd,
89: igf_aw_fund_mast fundmast,
90: igf_aw_fund_cat fundcat
91: WHERE awd.award_id = cp_award_id
92: AND awd.fund_id = fundmast.fund_id
93: AND fundmast.fund_code = fundcat.fund_code;

Line 777: igf_aw_fund_mast_all fmast,

773: select
774: fcat.alt_rel_code alt_rel_code
775: from
776: igf_aw_award_all awd,
777: igf_aw_fund_mast_all fmast,
778: igf_aw_fund_cat_all fcat
779: where
780: awd.fund_id = fmast.fund_id
781: and fmast.fund_code = fcat.fund_code

Line 1243: ,igf_aw_fund_mast_all fmast

1239: SELECT loans.loan_number
1240: FROM igf_sl_lor_all lor
1241: ,igf_sl_loans_all loans
1242: ,igf_aw_award_all awd
1243: ,igf_aw_fund_mast_all fmast
1244: ,igf_sl_cl_setup_all clset
1245: WHERE loans.loan_id = lor.loan_id
1246: AND loans.award_id = cp_n_award_id
1247: AND lor.prc_type_code IN ('GO','GP')

Line 1392: ,igf_aw_fund_mast_all fmast

1388: ,loans.loan_status loan_status
1389: FROM igf_sl_lor_all lor
1390: ,igf_sl_loans_all loans
1391: ,igf_aw_award_all awd
1392: ,igf_aw_fund_mast_all fmast
1393: ,igf_sl_cl_setup_all clset
1394: WHERE loans.loan_id = lor.loan_id
1395: AND loans.award_id = cp_n_award_id
1396: AND lor.prc_type_code IN ('GO','GP')

Line 1496: igf_aw_fund_mast_all fmast

1492: FROM
1493: igf_sl_lor_all lor,
1494: igf_sl_loans_all loans,
1495: igf_aw_award_all awd,
1496: igf_aw_fund_mast_all fmast
1497: WHERE
1498: loans.loan_id = lor.loan_id AND
1499: awd.award_id = loans.award_id AND
1500: fmast.fund_id = awd.fund_id AND

Line 1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;

1503: /* Local Variables */
1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;
1510:
1511: BEGIN

Line 1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;

1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;
1510:
1511: BEGIN
1512: -- Get Base_Id and related details