APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_FUND_MAST_ALL

Line 449: FROM igf_aw_fund_mast_all fmast,

445: RETURN VARCHAR2 IS
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:

Line 2002: igf_aw_fund_mast_all fmast,

1998: fmast.ci_cal_type,
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

Line 2646: igf_aw_fund_mast_all fmast,

2642: SELECT COUNT(*) + 1
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

Line 3170: l_fund igf_aw_fund_mast_all.fund_code%TYPE;

3166: lv_row_id ROWID;
3167: lv_incr_date NUMBER;
3168: l_found_loans VARCHAR2(1);
3169: l_awd igf_aw_award_all.award_id%TYPE;
3170: l_fund igf_aw_fund_mast_all.fund_code%TYPE;
3171: l_head VARCHAR2(1);
3172: ln_rec_count INTEGER;
3173:
3174: --For display of heading and parameters passed

Line 3207: igf_aw_fund_mast_all fmast,

3203: CURSOR cur_check_fund_award (p_base_id NUMBER, p_award_id NUMBER, p_fund_id NUMBER, p_cal_type VARCHAR2, p_seq_number NUMBER)
3204: IS
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