APPS.IGF_SP_AWARD dependencies on IGF_AW_FUND_CAT

Line 2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,

2231: -- This cursor definition is public to this package body;
2232: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
2233: cp_cal_type igs_ca_inst.cal_type%TYPE,
2234: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
2235: cp_v_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS
2238: SELECT fmast.*
2239: FROM igf_aw_fund_mast fmast ,

Line 2240: igf_aw_fund_cat fcat

2236: cp_v_disc_fund igf_aw_fund_mast.discontinue_fund%TYPE)
2237: IS
2238: SELECT fmast.*
2239: FROM igf_aw_fund_mast fmast ,
2240: igf_aw_fund_cat fcat
2241: WHERE fmast.fund_code = fcat.fund_code
2242: AND (fmast.fund_id = cp_fund_id OR cp_fund_id IS NULL)
2243: AND fmast.ci_cal_type = cp_cal_type
2244: AND fmast.ci_sequence_number = cp_sequence_number