APPS.IGF_SL_GEN dependencies on IGF_AW_AWARD_ALL

Line 1601: FUNCTION get_fed_fund_code (p_n_award_id IN igf_aw_award_all.award_id%TYPE,

1597:
1598: x_return_status := 'E';
1599: END get_stu_fao_code;
1600:
1601: FUNCTION get_fed_fund_code (p_n_award_id IN igf_aw_award_all.award_id%TYPE,
1602: p_v_message_name OUT NOCOPY VARCHAR2)
1603: RETURN igf_aw_fund_cat_all.fed_fund_code%TYPE AS
1604: ------------------------------------------------------------------
1605: --Created by : Sanil Madathil, Oracle IDC

Line 1621: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1617: --
1618: --Change History:
1619: --Who When What
1620: ------------------------------------------------------------------
1621: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1622: SELECT fund_id
1623: FROM igf_aw_award_all
1624: WHERE award_id = cp_n_award_id;
1625:

Line 1623: FROM igf_aw_award_all

1619: --Who When What
1620: ------------------------------------------------------------------
1621: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1622: SELECT fund_id
1623: FROM igf_aw_award_all
1624: WHERE award_id = cp_n_award_id;
1625:
1626: CURSOR c_igf_fmast_fcat (cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1627: SELECT fcat.fed_fund_code

Line 1696: ,igf_aw_award_all awd

1692: ) IS
1693: SELECT loans.loan_number
1694: FROM igf_sl_lor_all lor
1695: ,igf_sl_loans_all loans
1696: ,igf_aw_award_all awd
1697: ,igf_aw_fund_mast_all fmast
1698: WHERE lor.relationship_cd = cp_v_relationship_cd
1699: AND loans.loan_id = lor.loan_id
1700: AND (loans.loan_status = 'S' OR loans.loan_chg_status = 'S')

Line 1763: ,igf_aw_award_all awd

1759: ) IS
1760: SELECT loans.loan_number
1761: FROM igf_sl_lor_all lor
1762: ,igf_sl_loans_all loans
1763: ,igf_aw_award_all awd
1764: ,igf_aw_fund_mast_all fmast
1765: WHERE lor.relationship_cd = cp_v_relationship_cd
1766: AND loans.loan_id = lor.loan_id
1767: AND awd.award_id = loans.award_id