DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 364: g_flex_bnft_pool_id ben_elig_per_elctbl_chc.bnft_PRVDR_pool_id%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
368: --

Line 790: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

786:
787: --
788: -- eligiblitity
789: --
790: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
791: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%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;

Line 847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;

843: g_elig_rpt_group_name ben_rptg_grp.name%TYPE;
844: g_elig_rpt_group_id ben_rptg_grp.rptg_grp_id%TYPE;
845: g_elig_pl_yr_strdt ben_yr_perd.start_date%TYPE;
846: g_elig_pl_yr_enddt ben_yr_perd.end_date%TYPE;
847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;
848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;

Line 848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;

844: g_elig_rpt_group_id ben_rptg_grp.rptg_grp_id%TYPE;
845: g_elig_pl_yr_strdt ben_yr_perd.start_date%TYPE;
846: g_elig_pl_yr_enddt ben_yr_perd.end_date%TYPE;
847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;
848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;

Line 849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;

845: g_elig_pl_yr_strdt ben_yr_perd.start_date%TYPE;
846: g_elig_pl_yr_enddt ben_yr_perd.end_date%TYPE;
847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;
848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;

Line 850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;

846: g_elig_pl_yr_enddt ben_yr_perd.end_date%TYPE;
847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;
848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;

Line 851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;

847: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;
848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;

Line 852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;

848: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;
849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;

Line 853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;

849: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;
850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;

Line 854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;

850: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;
851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;

Line 855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;

851: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;
852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;

Line 856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;

852: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;
853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;