APPS.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_FUND_CAT_ALL

Line 684: igf_aw_fund_cat_all cat

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:
688: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

Line 824: igf_aw_fund_cat_all cat

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:
828: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

Line 964: igf_aw_fund_cat_all cat

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:
968: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

Line 1426: igf_aw_fund_cat_all cat

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:
1430: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

Line 1604: igf_aw_fund_cat_all cat

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:
1608: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;

Line 1783: igf_aw_fund_cat_all cat

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:
1787: l_fund_type igf_aw_fund_cat_v.fed_fund_code%TYPE;