APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_FUND_MAST_ALL

Line 681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

677: WHERE award_id = cp_award_id;
678:
679: sch_disb_date DATE;
680:
681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
682: SELECT cat.fed_fund_code
683: FROM igf_aw_fund_mast_all fund,
684: igf_aw_fund_cat_all cat
685: WHERE fund.fund_code = cat.fund_code

Line 683: FROM igf_aw_fund_mast_all fund,

679: sch_disb_date DATE;
680:
681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
682: SELECT cat.fed_fund_code
683: FROM igf_aw_fund_mast_all fund,
684: igf_aw_fund_cat_all cat
685: WHERE fund.fund_code = cat.fund_code
686: AND fund.fund_id = cp_fund_id;
687:

Line 821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

817: WHERE award_id = cp_award_id;
818:
819: sch_disb_date DATE;
820:
821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
822: SELECT cat.fed_fund_code
823: FROM igf_aw_fund_mast_all fund,
824: igf_aw_fund_cat_all cat
825: WHERE fund.fund_code = cat.fund_code

Line 823: FROM igf_aw_fund_mast_all fund,

819: sch_disb_date DATE;
820:
821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
822: SELECT cat.fed_fund_code
823: FROM igf_aw_fund_mast_all fund,
824: igf_aw_fund_cat_all cat
825: WHERE fund.fund_code = cat.fund_code
826: AND fund.fund_id = cp_fund_id;
827:

Line 961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

957: WHERE award_id = cp_award_id;
958:
959: sch_disb_date DATE;
960:
961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
962: SELECT cat.fed_fund_code
963: FROM igf_aw_fund_mast_all fund,
964: igf_aw_fund_cat_all cat
965: WHERE fund.fund_code = cat.fund_code

Line 963: FROM igf_aw_fund_mast_all fund,

959: sch_disb_date DATE;
960:
961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
962: SELECT cat.fed_fund_code
963: FROM igf_aw_fund_mast_all fund,
964: igf_aw_fund_cat_all cat
965: WHERE fund.fund_code = cat.fund_code
966: AND fund.fund_id = cp_fund_id;
967:

Line 1235: igf_aw_fund_mast_all fmast

1231: cp_award_id igf_aw_award_all.award_id%TYPE
1232: ) IS
1233: SELECT fmast.disb_rounding_code
1234: FROM igf_aw_award_all awd,
1235: igf_aw_fund_mast_all fmast
1236: WHERE awd.fund_id = fmast.fund_id
1237: AND awd.award_id = cp_award_id;
1238: rec_fund_mast c_get_disb_rounding%ROWTYPE;
1239:

Line 1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1419: WHERE award_id = cp_award_id;
1420:
1421: sch_disb_date DATE;
1422:
1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1424: SELECT cat.fed_fund_code
1425: FROM igf_aw_fund_mast_all fund,
1426: igf_aw_fund_cat_all cat
1427: WHERE fund.fund_code = cat.fund_code

Line 1425: FROM igf_aw_fund_mast_all fund,

1421: sch_disb_date DATE;
1422:
1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1424: SELECT cat.fed_fund_code
1425: FROM igf_aw_fund_mast_all fund,
1426: igf_aw_fund_cat_all cat
1427: WHERE fund.fund_code = cat.fund_code
1428: AND fund.fund_id = cp_fund_id;
1429:

Line 1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1597: WHERE award_id = cp_award_id;
1598:
1599: sch_disb_date DATE;
1600:
1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1602: SELECT cat.fed_fund_code
1603: FROM igf_aw_fund_mast_all fund,
1604: igf_aw_fund_cat_all cat
1605: WHERE fund.fund_code = cat.fund_code

Line 1603: FROM igf_aw_fund_mast_all fund,

1599: sch_disb_date DATE;
1600:
1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1602: SELECT cat.fed_fund_code
1603: FROM igf_aw_fund_mast_all fund,
1604: igf_aw_fund_cat_all cat
1605: WHERE fund.fund_code = cat.fund_code
1606: AND fund.fund_id = cp_fund_id;
1607:

Line 1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1776: WHERE award_id = cp_award_id;
1777:
1778: sch_disb_date DATE;
1779:
1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1781: SELECT cat.fed_fund_code
1782: FROM igf_aw_fund_mast_all fund,
1783: igf_aw_fund_cat_all cat
1784: WHERE fund.fund_code = cat.fund_code

Line 1782: FROM igf_aw_fund_mast_all fund,

1778: sch_disb_date DATE;
1779:
1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1781: SELECT cat.fed_fund_code
1782: FROM igf_aw_fund_mast_all fund,
1783: igf_aw_fund_cat_all cat
1784: WHERE fund.fund_code = cat.fund_code
1785: AND fund.fund_id = cp_fund_id;
1786: