APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on HRI_MB_BEN_ENRLACTN_CT

Line 19: 1.0.1 Generate the Person Ranges SQL. (From HRI_MB_BEN_ENRLACTN_CT).

15: 1.0.1 Truncate the Events Table.
16: 1.0.2 Generate the Person Ranges SQL. (From BEN_PER_IN_LER)
17:
18: Incremental Refresh
19: 1.0.1 Generate the Person Ranges SQL. (From HRI_MB_BEN_ENRLACTN_CT).
20:
21: 2. MULTI-THREADING
22: -------------------
23: 2.0 PROCESS_RANGE

Line 79: g_enrlactn_evnt_table VARCHAR2 (50) := 'HRI_MB_BEN_ENRLACTN_CT';

75: -- Global warning indicator
76: --
77: g_raise_warning VARCHAR2 (1);
78: --
79: g_enrlactn_evnt_table VARCHAR2 (50) := 'HRI_MB_BEN_ENRLACTN_CT';
80: g_package VARCHAR2 (50) := 'HRI_OPL_BEN_ENRL_ACTN';
81: -- -----------------------------------------------------------------------------
82: -- Inserts row into concurrent program log if debugging is enabled
83: -- -----------------------------------------------------------------------------

Line 417: INSERT INTO hri_mb_ben_enrlactn_ct

413: THEN
414: --
415: FORALL i IN l_per_in_ler_id_tab.FIRST .. l_per_in_ler_id_tab.LAST SAVE EXCEPTIONS
416: --
417: INSERT INTO hri_mb_ben_enrlactn_ct
418: ( sspnd_ind,
419: actn_item_ind,
420: interim_ind,
421: change_date,

Line 525: UPDATE hri_mb_ben_enrlactn_ct peac

521: IF l_per_in_ler_id_tab.COUNT > 0
522: THEN
523: --
524: FORALL i IN l_per_in_ler_id_tab.FIRST .. l_per_in_ler_id_tab.LAST SAVE EXCEPTIONS
525: UPDATE hri_mb_ben_enrlactn_ct peac
526: SET peac.effective_end_date = l_event_date_tab (i) - 1
527: WHERE peac.per_in_ler_id = l_per_in_ler_id_tab (i)
528: AND peac.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id_tab (i)
529: AND peac.prtt_enrt_actn_id = l_prtt_enrt_actn_id_tab (i)

Line 562: DELETE FROM hri_mb_ben_enrlactn_ct peac

558: IF l_per_in_ler_id_tab.COUNT > 0
559: THEN
560: --
561: FORALL i IN l_per_in_ler_id_tab.FIRST .. l_per_in_ler_id_tab.LAST SAVE EXCEPTIONS
562: DELETE FROM hri_mb_ben_enrlactn_ct peac
563: WHERE peac.asnd_lf_evt_dt = l_lf_evt_ocrd_dt_tab (i)
564: and peac.person_id = l_person_id_tab(i)
565: and peac.per_in_ler_id = l_per_in_ler_id_tab (i)
566: /* See Case(i) and Case(ii) above for clause below */

Line 608: DELETE from hri_mb_ben_enrlactn_ct

604: --
605: IF (g_collect_oe_only = 'Y') THEN
606: -- If Only Current Open Enrollment is being Collected,
607: -- Delete any prior run's stray records, if present.
608: DELETE from hri_mb_ben_enrlactn_ct
609: WHERE person_id = p_pil_rec.person_id
610: AND asnd_lf_evt_dt = p_pil_rec.lf_evt_ocrd_dt
611: AND per_in_ler_id = p_pil_rec.per_in_ler_id;
612: --

Line 618: INSERT INTO hri_mb_ben_enrlactn_ct

614: -- output('Start Of Full Refresh');
615: -- Populate Benefits Enrollment Actions Fact
616: -- Insert Actions (From Enrollment Action Items BEN_PRTT_ENRT_ACT_F)
617: --
618: INSERT INTO hri_mb_ben_enrlactn_ct
619: (
620: sspnd_ind,
621: actn_item_ind,
622: interim_ind,