DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 361: g_flex_bnft_pool_id ben_elig_per_elctbl_chc.bnft_PRVDR_pool_id%TYPE;

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

Line 787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

783:
784: --
785: -- eligiblitity
786: --
787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;

Line 844: g_elig_flex_01 ben_elig_per_elctbl_chc.epe_attribute1%TYPE;

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

Line 845: g_elig_flex_02 ben_elig_per_elctbl_chc.epe_attribute2%TYPE;

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

Line 846: g_elig_flex_03 ben_elig_per_elctbl_chc.epe_attribute3%TYPE;

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

Line 847: g_elig_flex_04 ben_elig_per_elctbl_chc.epe_attribute4%TYPE;

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

Line 848: g_elig_flex_05 ben_elig_per_elctbl_chc.epe_attribute5%TYPE;

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

Line 849: g_elig_flex_06 ben_elig_per_elctbl_chc.epe_attribute6%TYPE;

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

Line 850: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;

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

Line 851: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;

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

Line 852: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;

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

Line 853: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;

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