APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on HRI_EQ_BEN_ENRLACTN_EVTS

Line 306: p_sqlstr := p_sqlstr || ' FROM hri_eq_ben_enrlactn_evts peaq ';

302: -- Return the sql query to fetch PERSON_ID ranges
303: --
304: p_sqlstr := ' ';
305: p_sqlstr := p_sqlstr || ' SELECT DISTINCT peaq.person_id object_id ';
306: p_sqlstr := p_sqlstr || ' FROM hri_eq_ben_enrlactn_evts peaq ';
307: p_sqlstr := p_sqlstr || ' ORDER BY peaq.person_id ';
308: --
309: --
310: END IF;

Line 341: FROM hri_eq_ben_enrlactn_evts peaq

337: IS
338: SELECT per_in_ler_id, prtt_enrt_rslt_id, person_id, actn_typ_id,
339: event_date, lf_evt_ocrd_dt, due_dt, actn_typ_cd, rqd_flag,
340: cmpltd_dt, prtt_enrt_actn_id
341: FROM hri_eq_ben_enrlactn_evts peaq
342: WHERE per_in_ler_id = p_per_in_ler_id
343: AND event_cd = 'COMPLETED'
344: AND cmpltd_dt IS NOT NULL;
345: --

Line 354: FROM hri_eq_ben_enrlactn_evts peaq

350: IS
351: SELECT per_in_ler_id, prtt_enrt_rslt_id, person_id, actn_typ_id,
352: event_date, lf_evt_ocrd_dt, due_dt, actn_typ_cd, rqd_flag,
353: cmpltd_dt, prtt_enrt_actn_id
354: FROM hri_eq_ben_enrlactn_evts peaq
355: WHERE per_in_ler_id = p_per_in_ler_id AND event_cd = 'INSERTED';
356: --
357: -- Cursor to select all action items that were zapped since last refresh
358: -- 1. Delete the enrollment (bepearhi.pkb logs the event in queue)

Line 364: FROM hri_eq_ben_enrlactn_evts peaq

360: --
361: cursor c_peac is
362: SELECT peaq.lf_evt_ocrd_dt, peaq.person_id,
363: peaq.per_in_ler_id, peaq.PRTT_ENRT_ACTN_ID
364: FROM hri_eq_ben_enrlactn_evts peaq
365: WHERE peaq.per_in_ler_id = p_per_in_ler_id
366: AND peaq.person_id = p_person_id
367: AND peaq.event_cd IN ('ZAP');
368: --

Line 369: -- Variables for HRI_EQ_BEN_ENRLACTN_EVTS

365: WHERE peaq.per_in_ler_id = p_per_in_ler_id
366: AND peaq.person_id = p_person_id
367: AND peaq.event_cd IN ('ZAP');
368: --
369: -- Variables for HRI_EQ_BEN_ENRLACTN_EVTS
370: --
371: l_per_in_ler_id_tab g_per_in_ler_id_tab_type;
372: l_prtt_enrt_rslt_id_tab g_prtt_enrt_rslt_id_tab_type;
373: l_person_id_tab g_person_id_tab_type;

Line 384: -- End of Variables for HRI_EQ_BEN_ENRLACTN_EVTS

380: l_cmpltd_dt_tab g_cmpltd_dt_tab_type;
381: l_prtt_enrt_actn_id_tab g_prtt_enrt_actn_id_tab_type;
382: l_procedure VARCHAR2(100) := g_package || '.collect_enrlactn_evt [IR]';
383: --
384: -- End of Variables for HRI_EQ_BEN_ENRLACTN_EVTS
385: --
386: dml_errors EXCEPTION;
387: PRAGMA EXCEPTION_INIT (dml_errors, -24381);
388: --

Line 825: FROM hri_eq_ben_enrlactn_evts penq

821: --
822: CURSOR c_per_in_evt
823: IS
824: SELECT DISTINCT penq.person_id, penq.per_in_ler_id
825: FROM hri_eq_ben_enrlactn_evts penq
826: WHERE penq.person_id BETWEEN p_start_object_id
827: AND p_end_object_id
828: ORDER BY penq.person_id;
829: --

Line 975: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.HRI_EQ_BEN_ENRLACTN_EVTS';

971: --
972: -- Purge the Events Queue. The events queue needs to be purged
973: -- even after the after full refresh. Recollecting incremental changes
974: -- will be useless if a full refresh has been run.
975: EXECUTE IMMEDIATE 'truncate table ' || l_schema || '.HRI_EQ_BEN_ENRLACTN_EVTS';
976: --
977: END IF;
978: --
979: dbg ('Exiting post_process');