APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ENRT_RT

Line 195: from ben_enrt_rt ecr

191: cursor c_ecr_prv(p_elig_per_elctbl_chc_id in number) is
192: select ecr.enrt_rt_id,
193: ecr.acty_base_rt_id,
194: ecr.prtt_rt_val_id
195: from ben_enrt_rt ecr
196: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id and
197: ecr.business_group_id = p_business_group_id
198: and ecr.rt_usg_cd = 'IMPTDINC';
199: --

Line 269: l_ann_val ben_enrt_rt.ann_val%TYPE;

265: l_std_imp_inc_ded number;
266: --
267: l_mn_elcn_value number;
268: l_mx_elcn_value number;
269: l_ann_val ben_enrt_rt.ann_val%TYPE;
270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;

Line 270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;

266: --
267: l_mn_elcn_value number;
268: l_mx_elcn_value number;
269: l_ann_val ben_enrt_rt.ann_val%TYPE;
270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;

Line 271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;

267: l_mn_elcn_value number;
268: l_mx_elcn_value number;
269: l_ann_val ben_enrt_rt.ann_val%TYPE;
270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

Line 272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;

268: l_mx_elcn_value number;
269: l_ann_val ben_enrt_rt.ann_val%TYPE;
270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;

Line 273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;

269: l_ann_val ben_enrt_rt.ann_val%TYPE;
270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;

Line 274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;

270: l_ann_mn_elcn_val ben_enrt_rt.ann_mn_elcn_val%TYPE;
271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;

Line 275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

271: l_ann_mx_elcn_val ben_enrt_rt.ann_mx_elcn_val%TYPE;
272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;

Line 276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;

272: l_cmcd_val ben_enrt_rt.cmcd_val%TYPE;
273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;

Line 277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;

273: l_cmcd_mn_elcn_val ben_enrt_rt.cmcd_mn_elcn_val%TYPE;
274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;

Line 278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;

274: l_cmcd_mx_elcn_val ben_enrt_rt.cmcd_mx_elcn_val%TYPE;
275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;

Line 279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;

275: l_cmcd_acty_ref_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;

Line 280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;

276: l_actl_prem_id ben_enrt_rt.actl_prem_id%TYPE;
277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;

Line 281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;

277: l_cvg_calc_amt_mthd_id ben_enrt_rt.CVG_AMT_CALC_MTHD_ID%TYPE;
278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;

Line 282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;

278: l_bnft_rt_typ_cd ben_enrt_rt.bnft_rt_typ_cd%TYPE;
279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;

Line 283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;

279: l_rt_typ_cd ben_enrt_rt.rt_typ_cd%TYPE;
280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;

Line 284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;

280: l_rt_mlt_cd ben_enrt_rt.rt_mlt_cd%TYPE;
281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;

Line 285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;

281: l_comp_lvl_fctr_id ben_enrt_rt.comp_lvl_fctr_id%TYPE;
282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;

Line 286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;

282: l_entr_ann_val_flag ben_enrt_rt.entr_ann_val_flag%TYPE;
283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;

Line 287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;

283: l_ptd_comp_lvl_fctr_id ben_enrt_rt.ptd_comp_lvl_fctr_id%TYPE;
284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
291: l_incrt_val number;

Line 288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;

284: l_clm_comp_lvl_fctr_id ben_enrt_rt.clm_comp_lvl_fctr_id%TYPE;
285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
291: l_incrt_val number;
292: l_dflt_elcn_val number;

Line 289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;

285: l_ann_dflt_val ben_enrt_rt.ann_dflt_val%TYPE;
286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
291: l_incrt_val number;
292: l_dflt_elcn_val number;
293: l_acty_ref_perd_cd varchar2(100);

Line 290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;

286: l_rt_strt_dt ben_enrt_rt.rt_strt_dt%TYPE;
287: l_rt_strt_dt_rl ben_enrt_rt.rt_strt_dt_rl%TYPE;
288: l_rt_strt_dt_cd ben_enrt_rt.rt_strt_dt_cd%TYPE;
289: l_dsply_mn_elcn_val ben_enrt_rt.dsply_mn_elcn_val%TYPE;
290: l_dsply_mx_elcn_val ben_enrt_rt.dsply_mx_elcn_val%TYPE;
291: l_incrt_val number;
292: l_dflt_elcn_val number;
293: l_acty_ref_perd_cd varchar2(100);
294: l_tx_typ_cd varchar2(100);

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

325: l_BNFT_PRVDR_POOL_ID NUMBER;
326: --
327: l_proc varchar2(72) := g_package||'p_comp_imputed_income';
328: --
329: Type rate_id_type is table of ben_enrt_rt.enrt_rt_id%type index by BINARY_INTEGER;
330: Type rate_val_type is table of ben_enrt_rt.val%type index by BINARY_INTEGER;
331: --
332: rate_id_list rate_id_type;
333: rate_val_list rate_val_type;

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

326: --
327: l_proc varchar2(72) := g_package||'p_comp_imputed_income';
328: --
329: Type rate_id_type is table of ben_enrt_rt.enrt_rt_id%type index by BINARY_INTEGER;
330: Type rate_val_type is table of ben_enrt_rt.val%type index by BINARY_INTEGER;
331: --
332: rate_id_list rate_id_type;
333: rate_val_list rate_val_type;
334: l_count number;