DBA Data[Home] [Help]

APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_FUND_CAT_V

Line 688: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

684: igf_aw_fund_cat_all cat
685: WHERE fund.fund_code = cat.fund_code
686: AND fund.fund_id = cp_fund_id;
687:
688: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
689:
690: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
691: SELECT orig_action_code
692: FROM igf_gr_rfms

Line 828: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

824: igf_aw_fund_cat_all cat
825: WHERE fund.fund_code = cat.fund_code
826: AND fund.fund_id = cp_fund_id;
827:
828: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
829:
830: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
831: SELECT orig_action_code
832: FROM igf_gr_rfms

Line 968: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

964: igf_aw_fund_cat_all cat
965: WHERE fund.fund_code = cat.fund_code
966: AND fund.fund_id = cp_fund_id;
967:
968: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
969:
970: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
971: SELECT orig_action_code
972: FROM igf_gr_rfms

Line 1430: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

1426: igf_aw_fund_cat_all cat
1427: WHERE fund.fund_code = cat.fund_code
1428: AND fund.fund_id = cp_fund_id;
1429:
1430: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1431:
1432: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1433: SELECT orig_action_code
1434: FROM igf_gr_rfms

Line 1608: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

1604: igf_aw_fund_cat_all cat
1605: WHERE fund.fund_code = cat.fund_code
1606: AND fund.fund_id = cp_fund_id;
1607:
1608: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1609:
1610: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1611: SELECT orig_action_code
1612: FROM igf_gr_rfms

Line 1787: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

1783: igf_aw_fund_cat_all cat
1784: WHERE fund.fund_code = cat.fund_code
1785: AND fund.fund_id = cp_fund_id;
1786:
1787: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;
1788:
1789: CURSOR cur_orig_status_pell (cp_award_id NUMBER) IS
1790: SELECT orig_action_code
1791: FROM igf_gr_rfms