APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 313: from ben_prtt_enrt_rslt_f pen

309: l_proc varchar2(60) := 'ben_enrollment_process.check_pen';
310: --
311: cursor c_pen is
312: select 'x'
313: from ben_prtt_enrt_rslt_f pen
314: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
315: and pen.prtt_enrt_rslt_stat_cd is null
316: and pen.effective_end_date = hr_api.g_eot
317: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

Line 428: from ben_prtt_enrt_rslt_f pen

424: --
425: cursor c_pen_plnip is
426: select pen.prtt_enrt_rslt_id,
427: pen.object_version_number
428: from ben_prtt_enrt_rslt_f pen
429: where pen.pl_id = p_pl_id
430: and pen.person_id = p_person_id
431: and pen.effective_end_date = hr_api.g_eot
432: and pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 440: from ben_prtt_enrt_rslt_f pen

436: --
437: cursor c_pen_oiplnip is
438: select pen.prtt_enrt_rslt_id,
439: pen.object_version_number
440: from ben_prtt_enrt_rslt_f pen
441: where pen.oipl_id = l_oipl_id
442: and pen.person_id = p_person_id
443: and pen.effective_end_date = hr_api.g_eot
444: and pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 452: from ben_prtt_enrt_rslt_f pen

448: --
449: cursor c_pen_pl is
450: select pen.prtt_enrt_rslt_id,
451: pen.object_version_number
452: from ben_prtt_enrt_rslt_f pen
453: where pen.pgm_id = p_pgm_id
454: and pen.pl_id = p_pl_id
455: and pen.person_id = p_person_id
456: and pen.effective_end_date = hr_api.g_eot

Line 465: from ben_prtt_enrt_rslt_f pen

461: --
462: cursor c_pen_oipl is
463: select pen.prtt_enrt_rslt_id,
464: pen.object_version_number
465: from ben_prtt_enrt_rslt_f pen
466: where pen.pgm_id = p_pgm_id
467: and pen.oipl_id = l_oipl_id
468: and pen.person_id = p_person_id
469: and pen.effective_end_date = hr_api.g_eot

Line 542: from ben_prtt_enrt_rslt_f pen

538: --
539: cursor c_pen_plnip is
540: select pen.prtt_enrt_rslt_id,
541: pen.object_version_number
542: from ben_prtt_enrt_rslt_f pen
543: where pen.pl_id = p_pl_id
544: and pen.person_id = p_person_id
545: and (pen.effective_end_date <> hr_api.g_eot
546: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

Line 551: from ben_prtt_enrt_rslt_f pen

547: --
548: cursor c_pen_oiplnip is
549: select pen.prtt_enrt_rslt_id,
550: pen.object_version_number
551: from ben_prtt_enrt_rslt_f pen
552: where pen.oipl_id = l_oipl_id
553: and pen.person_id = p_person_id
554: and (pen.effective_end_date <> hr_api.g_eot
555: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

Line 560: from ben_prtt_enrt_rslt_f pen

556: --
557: cursor c_pen_pl is
558: select pen.prtt_enrt_rslt_id,
559: pen.object_version_number
560: from ben_prtt_enrt_rslt_f pen
561: where pen.pgm_id = p_pgm_id
562: and pen.pl_id = p_pl_id
563: and pen.person_id = p_person_id
564: and (pen.effective_end_date <> hr_api.g_eot

Line 570: from ben_prtt_enrt_rslt_f pen

566: --
567: cursor c_pen_oipl is
568: select pen.prtt_enrt_rslt_id,
569: pen.object_version_number
570: from ben_prtt_enrt_rslt_f pen
571: where pen.pgm_id = p_pgm_id
572: and pen.oipl_id = l_oipl_id
573: and pen.person_id = p_person_id
574: and (pen.effective_end_date <> hr_api.g_eot

Line 1723: update ben_prtt_enrt_rslt_f

1719: --
1720: --Set the Original Coverage Start Date
1721: IF p_orgnl_enrt_dt IS NOT NULL and l_prtt_enrt_rslt_id IS NOT NULL THEN
1722: --
1723: update ben_prtt_enrt_rslt_f
1724: set ORGNL_ENRT_DT = p_orgnl_enrt_dt
1725: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id ;
1726: --
1727: END IF;

Line 2552: from ben_prtt_enrt_rslt_f

2548: --
2549: cursor get_rslt_ovn_c is
2550: select object_version_number,
2551: sspndd_flag
2552: from ben_prtt_enrt_rslt_f
2553: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
2554: and business_group_id = p_business_group_id
2555: and p_effective_date
2556: between effective_start_date and effective_end_date;