DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ENRT_RT

Line 85: update ben_enrt_rt set prtt_rt_val_id = NULL

81: hr_utility.set_location (' delete past rate prv', 2);
82: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
83:
84: -- Nullify the prv_id on enrt_rt
85: update ben_enrt_rt set prtt_rt_val_id = NULL
86: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);
87:
88: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);
89: -- delete the rate

Line 254: update ben_enrt_rt set prtt_rt_val_id = NULL

250: hr_utility.set_location (' delete future rate prv', 2);
251: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
252:
253: -- Nullify the prv_id on enrt_rt
254: update ben_enrt_rt set prtt_rt_val_id = NULL
255: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);
256:
257: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);
258: -- delete the rate

Line 681: from ben_enrt_rt ecr

677: cursor c_ecr_prv(p_elig_per_elctbl_chc_id in number) is
678: select ecr.enrt_rt_id,
679: ecr.acty_base_rt_id,
680: ecr.prtt_rt_val_id
681: from ben_enrt_rt ecr
682: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id and
683: ecr.business_group_id = p_business_group_id
684: and ecr.rt_usg_cd = 'IMPTDINC';
685: --

Line 805: l_ann_val ben_enrt_rt.ann_val%TYPE;

801: l_std_imp_inc_ded number;
802: --
803: l_mn_elcn_value number;
804: l_mx_elcn_value number;
805: l_ann_val ben_enrt_rt.ann_val%TYPE;
806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;

Line 806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;

802: --
803: l_mn_elcn_value number;
804: l_mx_elcn_value number;
805: l_ann_val ben_enrt_rt.ann_val%TYPE;
806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;

Line 807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;

803: l_mn_elcn_value number;
804: l_mx_elcn_value number;
805: l_ann_val ben_enrt_rt.ann_val%TYPE;
806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

Line 808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;

804: l_mx_elcn_value number;
805: l_ann_val ben_enrt_rt.ann_val%TYPE;
806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;

Line 809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;

805: l_ann_val ben_enrt_rt.ann_val%TYPE;
806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;

Line 810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;

806: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;

Line 811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

807: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;

Line 812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;

808: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;

Line 813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;

809: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;

Line 814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;

810: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;

Line 815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;

811: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;

Line 816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;

812: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;

Line 817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;

813: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;

Line 818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;

814: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;

Line 819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;

815: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;

Line 820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;

816: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;

Line 821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;

817: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;

Line 822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;

818: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;

Line 823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;

819: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
827: l_incrt_val number;

Line 824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;

820: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
827: l_incrt_val number;
828: l_dflt_elcn_val number;

Line 825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;

821: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
827: l_incrt_val number;
828: l_dflt_elcn_val number;
829: l_acty_ref_perd_cd varchar2(100);

Line 826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;

822: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
823: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
824: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
825: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
826: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
827: l_incrt_val number;
828: l_dflt_elcn_val number;
829: l_acty_ref_perd_cd varchar2(100);
830: l_tx_typ_cd varchar2(100);

Line 865: Type rate_id_type is table of ben_enrt_rt.enrt_rt_id%type index by BINARY_INTEGER;

861: l_BNFT_PRVDR_POOL_ID NUMBER;
862: --
863: l_proc varchar2(72) := g_package||'p_comp_imp_inc_internal';
864: --
865: Type rate_id_type is table of ben_enrt_rt.enrt_rt_id%type index by BINARY_INTEGER;
866: Type rate_val_type is table of ben_enrt_rt.val%type index by BINARY_INTEGER;
867: --
868: rate_id_list rate_id_type;
869: rate_val_list rate_val_type;

Line 866: Type rate_val_type is table of ben_enrt_rt.val%type index by BINARY_INTEGER;

862: --
863: l_proc varchar2(72) := g_package||'p_comp_imp_inc_internal';
864: --
865: Type rate_id_type is table of ben_enrt_rt.enrt_rt_id%type index by BINARY_INTEGER;
866: Type rate_val_type is table of ben_enrt_rt.val%type index by BINARY_INTEGER;
867: --
868: rate_id_list rate_id_type;
869: rate_val_list rate_val_type;
870: l_count number;