DBA Data[Home] [Help]

APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on HR_API

Line 447: hr_api.g_eot,

443: DECODE (pen.rplcs_sspndd_rslt_id, NULL, 0, 1),
444: l_event_date_tab (i),
445: --l_event_date_tab (i),
446: pen.effective_start_Date,
447: hr_api.g_eot,
448: l_person_id_tab (i),
449: l_lf_evt_ocrd_dt_tab (i),
450: l_actn_typ_cd_tab (i),
451: copd.compobj_sk_pk compobj_sk_pk,

Line 694: -- AND pen.effective_end_date = hr_api.g_eot /* Bug 4562628 */

690: OR (pen_int.oipl_id IS NULL AND NVL(copd_int.oipl_id,-1) = -1)
691: )
692: AND copd_int.pgm_id(+) = pen_int.pgm_id
693: AND copd_int.pl_id(+) = pen_int.pl_id
694: -- AND pen.effective_end_date = hr_api.g_eot /* Bug 4562628 */
695: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
696: AND pen.prtt_enrt_rslt_stat_cd IS NULL
697: /* Bug 4562628 */
698: and pea.effective_Start_date between pen.effective_Start_date and pen.effective_end_date

Line 695: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

691: )
692: AND copd_int.pgm_id(+) = pen_int.pgm_id
693: AND copd_int.pl_id(+) = pen_int.pl_id
694: -- AND pen.effective_end_date = hr_api.g_eot /* Bug 4562628 */
695: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
696: AND pen.prtt_enrt_rslt_stat_cd IS NULL
697: /* Bug 4562628 */
698: and pea.effective_Start_date between pen.effective_Start_date and pen.effective_end_date
699: and ( pen_int.effective_start_date is null