APPS.IGF_AW_GEN_003 dependencies on IGF_AW_FUND_CAT

Line 86: FROM igf_aw_fund_cat fcat,

82:
83: CURSOR cur_get_fund (p_fund_id NUMBER)
84: IS
85: SELECT fcat.fed_fund_code
86: FROM igf_aw_fund_cat fcat,
87: igf_aw_fund_mast fmast
88: WHERE fcat.fund_code = fmast.fund_code
89: AND fmast.fund_id = p_fund_id;
90:

Line 769: FROM igf_aw_fund_cat fcat,

765: -- Get fed fund code
766: CURSOR cur_get_fund (p_fund_id NUMBER)
767: IS
768: SELECT fcat.fed_fund_code
769: FROM igf_aw_fund_cat fcat,
770: igf_aw_fund_mast fmast
771: WHERE fcat.fund_code = fmast.fund_code
772: AND fmast.fund_id = p_fund_id;
773:

Line 1050: igf_aw_fund_cat fcat

1046: fund.disb_verf_da,
1047: fund.show_on_bill,
1048: fund.nslds_disb_da
1049: FROM igf_aw_fund_mast fund,
1050: igf_aw_fund_cat fcat
1051: WHERE fund_id = cp_fund_id
1052: AND fund.fund_code = fcat.fund_code;
1053: l_get_fund_dtls cur_get_fund_dtls%ROWTYPE;
1054:

Line 3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

3142: FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
3143: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,
3149: p_act_isir IN VARCHAR2,
3150: p_ld_seq_number IN NUMBER,

Line 4101: FROM igf_aw_fund_cat fcat,

4097: CURSOR cur_fed_fund_code(
4098: p_award_id NUMBER
4099: ) IS
4100: SELECT fcat.fed_fund_code
4101: FROM igf_aw_fund_cat fcat,
4102: igf_aw_fund_mast fmast,
4103: igf_aw_award_all awd
4104: WHERE fcat.fund_code = fmast.fund_code
4105: AND fmast.fund_id = awd.fund_id