474: --
475: --------------------------------------------------------------------------------
476:
477: -- Get the details of the existing Inclusive Funds for a given Fund ID
478: CURSOR c_fund_incl( cp_ref_fund_id igf_aw_fund_incl_all.fund_id%TYPE
479: ) IS
480: SELECT incl.fund_code
481: FROM igf_aw_fund_incl_all incl
482: WHERE incl.fund_id = cp_ref_fund_id;
477: -- Get the details of the existing Inclusive Funds for a given Fund ID
478: CURSOR c_fund_incl( cp_ref_fund_id igf_aw_fund_incl_all.fund_id%TYPE
479: ) IS
480: SELECT incl.fund_code
481: FROM igf_aw_fund_incl_all incl
482: WHERE incl.fund_id = cp_ref_fund_id;
483:
484: -- check whether the fund is a discontinued fund or not
485: CURSOR c_chk_disc_fund( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,