APPS.IGF_SL_REL_DISB dependencies on IGF_AW_FUND_CAT

Line 363: FROM igf_aw_fund_mast_all fmast,igf_aw_fund_cat_all fcat

359:
360: CURSOR cur_get_fed_fund_code(p_fund_id NUMBER)
361: IS
362: SELECT fcat.fed_fund_code
363: FROM igf_aw_fund_mast_all fmast,igf_aw_fund_cat_all fcat
364: WHERE fmast.fund_id = p_fund_id
365: AND fmast.fund_code = fcat.fund_code;
366:
367: get_fed_fund_code cur_get_fed_fund_code%ROWTYPE;

Line 1767: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1763: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1764: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1765: cat.fed_fund_code
1766: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1767: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1768: WHERE adisb.award_id = awd.award_id
1769: AND fmast.fund_code = cat.fund_code
1770: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1771: AND awd.fund_id = p_fund_id

Line 1796: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1792: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1793: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1794: cat.fed_fund_code
1795: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1796: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1797: WHERE adisb.award_id = awd.award_id
1798: AND fmast.fund_code = cat.fund_code
1799: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1800: AND awd.fund_id = p_fund_id

Line 1822: igf_aw_award_all awd, igf_aw_fund_cat_all cat

1818: SELECT adisb.*, awd.base_id, fmast.ci_cal_type,
1819: fmast.ci_sequence_number, fmast.fund_id, fmast.fund_code,
1820: cat.fed_fund_code
1821: FROM igf_aw_awd_disb_all adisb, igf_aw_fund_mast_all fmast,
1822: igf_aw_award_all awd, igf_aw_fund_cat_all cat
1823: WHERE adisb.award_id = awd.award_id
1824: AND fmast.fund_code = cat.fund_code
1825: AND fmast.fund_id = awd.fund_id AND awd.base_id = p_base_id
1826: AND awd.fund_id = p_fund_id

Line 1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast

1867: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1868: )
1869: IS
1870: SELECT cat.fed_fund_code
1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast
1872: WHERE fmast.fund_code = cat.fund_code AND fmast.fund_id = p_fund_id;
1873:
1874: get_fed_fund_code_rec cur_get_fed_fund_code%ROWTYPE;
1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 3368: igf_aw_fund_cat fcat

3364: IS
3365: SELECT DISTINCT awd.base_id base_id, fcat.fed_fund_code
3366: fed_fund_code
3367: FROM igf_aw_award awd, igf_aw_fund_mast fmast,
3368: igf_aw_fund_cat fcat
3369: WHERE awd.fund_id = p_fund_id
3370: AND awd.fund_id = fmast.fund_id
3371: AND fmast.fund_code = fcat.fund_code
3372: AND awd.award_status = 'ACCEPTED';

Line 3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast

3387: -- Get the fund type
3388: CURSOR cur_get_fund_type(p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3389: IS
3390: SELECT cat.fed_fund_code fed_fund_code
3391: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all mast
3392: WHERE mast.fund_code = cat.fund_code AND mast.fund_id = p_fund_id;
3393:
3394: get_fund_type_rec cur_get_fund_type%ROWTYPE;
3395: lv_group_type igs_pe_persid_group_v.group_type%TYPE;