APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_FUND_CAT_ALL

Line 450: igf_aw_fund_cat_all fcat

446: CURSOR cur_get_fund_desc (p_fund_id NUMBER)
447: IS
448: SELECT fcat.fund_code||'-'||fmast.description description
449: FROM igf_aw_fund_mast_all fmast,
450: igf_aw_fund_cat_all fcat
451: WHERE fmast.fund_id = p_fund_id
452: AND fcat.fund_code = fmast.fund_code;
453:
454: get_fund_desc_rec cur_get_fund_desc%ROWTYPE;

Line 2003: igf_aw_fund_cat_all fcat,

1999: fmast.ci_sequence_number
2000: FROM igf_sl_loans_all loan,
2001: igf_aw_award_all awd,
2002: igf_aw_fund_mast_all fmast,
2003: igf_aw_fund_cat_all fcat,
2004: igf_ap_fa_base_rec_all fa
2005: WHERE loan.award_id = awd.award_id
2006: AND awd.fund_id = fmast.fund_id
2007: AND fmast.fund_code = fcat.fund_code

Line 2647: igf_aw_fund_cat_all fcat,

2643: FROM
2644: igf_sl_loans_all loan,
2645: igf_aw_award_all awd,
2646: igf_aw_fund_mast_all fmast,
2647: igf_aw_fund_cat_all fcat,
2648: igf_ap_fa_base_rec_all fabase
2649: WHERE
2650: loan.award_id = awd.award_id AND
2651: awd.fund_id = fmast.fund_id AND

Line 3209: igf_aw_fund_cat_all fcat

3205: SELECT awd.award_id,fmast.fund_code
3206: FROM igf_aw_award_all awd,
3207: igf_aw_fund_mast_all fmast,
3208: igf_ap_fa_base_rec_all base,
3209: igf_aw_fund_cat_all fcat
3210: WHERE awd.fund_id = fmast.fund_id
3211: AND awd.base_id = base.base_id
3212: AND awd.award_status = 'ACCEPTED'
3213: AND fmast.fund_code = fcat.fund_code