DBA Data[Home] [Help]

APPS.HRI_OPL_BEN_ELIG_ENRL_EQ dependencies on HRI_EQ_BEN_ELIGENRL_EVTS

Line 4: Name : HRI_EQ_BEN_ELIGENRL_EVTS

1: PACKAGE BODY hri_opl_ben_elig_enrl_eq AS
2: /* $Header: hrieqeec.pkb 120.2 2005/11/15 01:10:53 bmanyam noship $ */
3: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4: Name : HRI_EQ_BEN_ELIGENRL_EVTS
5: -- Purpose : Populate event queue table
6: --
7: -- PROCEDURE insert_event
8: -- insert_event

Line 90: INSERT INTO hri_eq_ben_eligenrl_evts

86: p_datetrack_mode IN VARCHAR2
87: )
88: IS
89: BEGIN
90: INSERT INTO hri_eq_ben_eligenrl_evts
91: (person_id,
92: per_in_ler_id,
93: prtt_enrt_rslt_id,
94: interim_enrt_rslt_id,

Line 154: INSERT INTO hri_eq_ben_eligenrl_evts

150: IF (p_rec.effective_end_date <> hr_api.g_eot
151: OR p_rec.enrt_cvg_thru_dt <> hr_api.g_eot) THEN
152: -- 4714512 : Suspended Enrollments also need to be counted as enrolled
153: --
154: INSERT INTO hri_eq_ben_eligenrl_evts
155: (person_id,
156: per_in_ler_id,
157: prtt_enrt_rslt_id,
158: interim_enrt_rslt_id,

Line 214: INSERT INTO hri_eq_ben_eligenrl_evts

210: p_datetrack_mode IN VARCHAR2
211: )
212: IS
213: BEGIN
214: INSERT INTO hri_eq_ben_eligenrl_evts
215: (person_id,
216: per_in_ler_id,
217: prtt_enrt_rslt_id,
218: interim_enrt_rslt_id,