[Home] [Help]
77: --
78: g_raise_warning VARCHAR2(1);
79: --
80: g_eligenrl_evnt_table VARCHAR2(50) := 'HRI_MB_BEN_ELIGENRL_EVNT_CT';
81: g_elctn_evnt_table VARCHAR2(50) := 'HRI_MB_BEN_ELCTN_EVNT_CT';
82: --
83: g_elctn_evts_eq_table VARCHAR2(50) := 'HRI_EQ_BEN_ELCTN_EVTS';
84: g_eligenrl_evts_eq_table VARCHAR2(50) := 'HRI_EQ_BEN_ELIGENRL_EVTS';
85:
484: --
485: IF (g_collect_oe_only = 'Y' AND g_full_refresh = 'Y') THEN
486: -- If Only Current Open Enrollment is being Collected,
487: -- Delete any stray records, if present.
488: DELETE from hri_mb_ben_elctn_evnt_ct
489: WHERE person_id = p_pil_rec.person_id
490: AND asnd_lf_evt_dt = p_pil_rec.lf_evt_ocrd_dt;
491: --
492: END IF;
490: AND asnd_lf_evt_dt = p_pil_rec.lf_evt_ocrd_dt;
491: --
492: END IF;
493: -- Populate Benefit Election Event Fact
494: INSERT INTO hri_mb_ben_elctn_evnt_ct
495: ( elig_ind
496: ,enrt_ind
497: ,not_enrt_ind
498: ,dflt_ind
687: AND penc.asnd_lf_evt_dt = l_pil_rec.lf_evt_ocrd_dt
688: AND penc.per_in_ler_id = p_per_in_ler_id;
689:
690: -- 2. Update Election Events to Reset Flags.
691: UPDATE hri_mb_ben_elctn_evnt_ct pelc
692: SET pelc.elig_ind = 0
693: ,pelc.enrt_ind = 0
694: ,pelc.not_enrt_ind = 0
695: ,pelc.dflt_ind = 0
715: AND penc.asnd_lf_evt_dt = l_pil_rec.lf_evt_ocrd_dt
716: AND penc.per_in_ler_id = i.per_in_ler_id;
717:
718: -- 2. Delete Any Back-out / Voided Eligibility Events
719: DELETE FROM hri_mb_ben_elctn_evnt_ct pelc
720: WHERE pelc.person_id = p_person_id
721: AND pelc.asnd_lf_evt_dt = l_pil_rec.lf_evt_ocrd_dt
722: AND pelc.per_in_ler_id = i.per_in_ler_id;
723: --
742: --
743: IF (l_elcn_evt_tbl.COUNT > 0) THEN
744: FOR i IN l_elcn_evt_tbl.FIRST..l_elcn_evt_tbl.LAST LOOP
745: --
746: UPDATE HRI_MB_BEN_ELCTN_EVNT_CT pelc
747: SET pelc.elig_ind = l_elcn_evt_tbl(i).elig_ind
748: ,pelc.enrt_ind = l_elcn_evt_tbl(i).enrt_ind
749: ,pelc.not_enrt_ind = l_elcn_evt_tbl(i).not_enrt_ind
750: ,pelc.dflt_ind = l_elcn_evt_tbl(i).dflt_ind