eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PRTT_ENRT_RSLT_F

Line 363: g_flex_currency ben_prtt_enrt_rslt_f.uom%TYPE;

359: g_flex_cmbn_ptip_name ben_cmbn_ptip_f.name%TYPE;
360: g_flex_cmbn_ptip_opt_id ben_cmbn_ptip_opt_f.cmbn_ptip_opt_id%TYPE;
361: g_flex_cmbn_ptip_opt_name ben_cmbn_ptip_opt_f.name%TYPE;
362: g_flex_amt ben_prtt_rt_val.rt_val%TYPE;
363: g_flex_currency ben_prtt_enrt_rslt_f.uom%TYPE;
364: g_flex_bnft_pool_id ben_elig_per_elctbl_chc.bnft_PRVDR_pool_id%TYPE;
365: g_flex_bnft_pool_name ben_bnft_prvdr_pool_f.name%type;
366: --
367: -- detail - enrollment

Line 370: g_enrt_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;

366: --
367: -- detail - enrollment
368: --
369: /* Start of Changes for WWBUG: 1828349 added */
370: g_enrt_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
371: /* End of Changes for WWBUG: 1828349 added */
372: g_enrt_pl_name ben_pl_f.name%TYPE;
373: g_enrt_opt_name ben_opt_f.name%TYPE;
374: g_enrt_pl_id ben_pl_f.pl_id%TYPE;

Line 380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;

376: g_enrt_pgm_id ben_pgm_f.pgm_id%TYPE;
377: g_enrt_pgm_name ben_pgm_f.name%TYPE;
378: g_enrt_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
379: g_enrt_pl_typ_name ben_pl_typ_f.name%TYPE;
380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;

Line 381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;

377: g_enrt_pgm_name ben_pgm_f.name%TYPE;
378: g_enrt_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
379: g_enrt_pl_typ_name ben_pl_typ_f.name%TYPE;
380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;

Line 382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;

378: g_enrt_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
379: g_enrt_pl_typ_name ben_pl_typ_f.name%TYPE;
380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;

Line 383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;

379: g_enrt_pl_typ_name ben_pl_typ_f.name%TYPE;
380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;

Line 384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;

380: g_enrt_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;

Line 385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;

381: g_enrt_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;

Line 386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;

382: g_enrt_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;

Line 387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;

383: g_enrt_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;

Line 388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;

384: g_enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%TYPE;
385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;

Line 389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;

385: g_enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%TYPE;
386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;

Line 390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;

386: g_enrt_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
394: g_enrt_total_premium_amt ben_prtt_prem_f.std_prem_val%TYPE;

Line 391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;

387: g_enrt_benefit_order_num ben_prtt_enrt_rslt_f.bnft_ordr_num%TYPE;
388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
394: g_enrt_total_premium_amt ben_prtt_prem_f.std_prem_val%TYPE;
395: g_enrt_total_premium_uom ben_prtt_prem_f.std_prem_uom%TYPE;

Line 392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;

388: g_enrt_method ben_prtt_enrt_rslt_f.enrt_mthd_cd%TYPE;
389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
394: g_enrt_total_premium_amt ben_prtt_prem_f.std_prem_val%TYPE;
395: g_enrt_total_premium_uom ben_prtt_prem_f.std_prem_uom%TYPE;
396: g_enrt_uom ben_prtt_enrt_rslt_f.uom%TYPE;

Line 393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;

389: g_enrt_ovrd_flag ben_prtt_enrt_rslt_f.enrt_ovridn_flag%TYPE;
390: g_enrt_ovrd_thru_dt ben_prtt_enrt_rslt_f.enrt_ovrid_thru_dt%TYPE;
391: g_enrt_ovrd_reason ben_prtt_enrt_rslt_f.enrt_ovrid_rsn_cd%TYPE;
392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
394: g_enrt_total_premium_amt ben_prtt_prem_f.std_prem_val%TYPE;
395: g_enrt_total_premium_uom ben_prtt_prem_f.std_prem_uom%TYPE;
396: g_enrt_uom ben_prtt_enrt_rslt_f.uom%TYPE;
397: g_enrt_rpt_group_name ben_rptg_grp.name%TYPE;

Line 396: g_enrt_uom ben_prtt_enrt_rslt_f.uom%TYPE;

392: g_enrt_suspended_flag ben_prtt_enrt_rslt_f.sspndd_flag%TYPE;
393: g_enrt_rslt_effct_strdt ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
394: g_enrt_total_premium_amt ben_prtt_prem_f.std_prem_val%TYPE;
395: g_enrt_total_premium_uom ben_prtt_prem_f.std_prem_uom%TYPE;
396: g_enrt_uom ben_prtt_enrt_rslt_f.uom%TYPE;
397: g_enrt_rpt_group_name ben_rptg_grp.name%TYPE;
398: g_enrt_rpt_group_id ben_rptg_grp.rptg_grp_id%TYPE;
399: g_enrt_pl_yr_strdt ben_yr_perd.start_date%TYPE;
400: g_enrt_pl_yr_enddt ben_yr_perd.end_date%TYPE;

Line 401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;

397: g_enrt_rpt_group_name ben_rptg_grp.name%TYPE;
398: g_enrt_rpt_group_id ben_rptg_grp.rptg_grp_id%TYPE;
399: g_enrt_pl_yr_strdt ben_yr_perd.start_date%TYPE;
400: g_enrt_pl_yr_enddt ben_yr_perd.end_date%TYPE;
401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;
402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;

Line 402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;

398: g_enrt_rpt_group_id ben_rptg_grp.rptg_grp_id%TYPE;
399: g_enrt_pl_yr_strdt ben_yr_perd.start_date%TYPE;
400: g_enrt_pl_yr_enddt ben_yr_perd.end_date%TYPE;
401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;
402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;

Line 403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;

399: g_enrt_pl_yr_strdt ben_yr_perd.start_date%TYPE;
400: g_enrt_pl_yr_enddt ben_yr_perd.end_date%TYPE;
401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;
402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;

Line 404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;

400: g_enrt_pl_yr_enddt ben_yr_perd.end_date%TYPE;
401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;
402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;

Line 405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;

401: g_enrt_attr_1 ben_prtt_enrt_rslt_f.pen_attribute1%TYPE;
402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;

Line 406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;

402: g_enrt_attr_2 ben_prtt_enrt_rslt_f.pen_attribute2%TYPE;
403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;

Line 407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;

403: g_enrt_attr_3 ben_prtt_enrt_rslt_f.pen_attribute3%TYPE;
404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;

Line 408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;

404: g_enrt_attr_4 ben_prtt_enrt_rslt_f.pen_attribute4%TYPE;
405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

Line 409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;

405: g_enrt_attr_5 ben_prtt_enrt_rslt_f.pen_attribute5%TYPE;
406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;

Line 410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;

406: g_enrt_attr_6 ben_prtt_enrt_rslt_f.pen_attribute6%TYPE;
407: g_enrt_attr_7 ben_prtt_enrt_rslt_f.pen_attribute7%TYPE;
408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;

Line 412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;

408: g_enrt_attr_8 ben_prtt_enrt_rslt_f.pen_attribute8%TYPE;
409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;

Line 413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;

409: g_enrt_attr_9 ben_prtt_enrt_rslt_f.pen_attribute9%TYPE;
410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;

Line 506: g_enrt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;

502: g_prem_type ben_actl_prem_f.actl_prem_typ_cd%TYPE;
503: g_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
504: g_enrt_mntot_prem_amt ben_prtt_prem_by_mo_f.val%TYPE;
505: g_enrt_mntot_prem_cramt ben_prtt_prem_by_mo_f.cr_val%TYPE;
506: g_enrt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
509: g_enrt_intrcovg_flag varchar2(30);
510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

Line 507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;

503: g_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
504: g_enrt_mntot_prem_amt ben_prtt_prem_by_mo_f.val%TYPE;
505: g_enrt_mntot_prem_cramt ben_prtt_prem_by_mo_f.cr_val%TYPE;
506: g_enrt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
509: g_enrt_intrcovg_flag varchar2(30);
510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
511: g_enrt_int_pl_name ben_pl_f.name%TYPE;

Line 508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;

504: g_enrt_mntot_prem_amt ben_prtt_prem_by_mo_f.val%TYPE;
505: g_enrt_mntot_prem_cramt ben_prtt_prem_by_mo_f.cr_val%TYPE;
506: g_enrt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
509: g_enrt_intrcovg_flag varchar2(30);
510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
511: g_enrt_int_pl_name ben_pl_f.name%TYPE;
512: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;

Line 510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;

506: g_enrt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
509: g_enrt_intrcovg_flag varchar2(30);
510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
511: g_enrt_int_pl_name ben_pl_f.name%TYPE;
512: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
513: g_enrt_int_opt_name ben_opt_f.name%TYPE;
514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;

Line 514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;

510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
511: g_enrt_int_pl_name ben_pl_f.name%TYPE;
512: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
513: g_enrt_int_opt_name ben_opt_f.name%TYPE;
514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
515: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
516: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;
517: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;
518: g_enrt_pgm_fd_name ben_pgm_f.short_name%Type ;

Line 796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;

792: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
793: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
794: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
795: g_elig_pl_name ben_pl_f.name%TYPE;
796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
800: g_elig_opt_name ben_opt_f.name%TYPE;

Line 797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;

793: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
794: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
795: g_elig_pl_name ben_pl_f.name%TYPE;
796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
800: g_elig_opt_name ben_opt_f.name%TYPE;
801: g_elig_cvg_amt ben_enrt_bnft.val%TYPE;

Line 798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;

794: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
795: g_elig_pl_name ben_pl_f.name%TYPE;
796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
800: g_elig_opt_name ben_opt_f.name%TYPE;
801: g_elig_cvg_amt ben_enrt_bnft.val%TYPE;
802: g_elig_cvg_min_amt ben_enrt_bnft.MN_VAL%TYPE;

Line 799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;

795: g_elig_pl_name ben_pl_f.name%TYPE;
796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
800: g_elig_opt_name ben_opt_f.name%TYPE;
801: g_elig_cvg_amt ben_enrt_bnft.val%TYPE;
802: g_elig_cvg_min_amt ben_enrt_bnft.MN_VAL%TYPE;
803: g_elig_cvg_max_amt ben_enrt_bnft.MX_VAL%TYPE;