DBA Data[Home] [Help]

APPS.IGF_SP_ROLLOVER dependencies on IGF_AW_FUND_CAT

Line 103: igf_aw_fund_cat fcat

99: -- This cursor definition is public to this package body;
100: CURSOR c_igf_aw_fund_mast(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
101: SELECT fmast.*
102: FROM igf_aw_fund_mast fmast ,
103: igf_aw_fund_cat fcat
104: WHERE fmast.fund_code = fcat.fund_code
105: AND fmast.fund_id = cp_fund_id
106: AND fcat.sys_fund_type = g_c_fund_type
107: AND fmast.discontinue_fund = g_c_no;

Line 969: igf_aw_fund_cat fcat

965: cp_sequence_number igs_ca_inst.sequence_number%TYPE
966: ) IS
967: SELECT fmast.*
968: FROM igf_aw_fund_mast fmast ,
969: igf_aw_fund_cat fcat
970: WHERE fmast.fund_code = fcat.fund_code
971: AND fmast.fund_code = cp_fund_code
972: AND fmast.ci_cal_type = cp_cal_type
973: AND fmast.ci_sequence_number = cp_sequence_number