APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 310: from ben_prtt_enrt_rslt_f pen

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

Line 425: from ben_prtt_enrt_rslt_f pen

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

Line 437: from ben_prtt_enrt_rslt_f pen

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

Line 449: from ben_prtt_enrt_rslt_f pen

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

Line 462: from ben_prtt_enrt_rslt_f pen

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

Line 539: from ben_prtt_enrt_rslt_f pen

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

Line 548: from ben_prtt_enrt_rslt_f pen

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

Line 557: from ben_prtt_enrt_rslt_f pen

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

Line 567: from ben_prtt_enrt_rslt_f pen

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

Line 1720: update ben_prtt_enrt_rslt_f

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

Line 2519: from ben_prtt_enrt_rslt_f

2515: --
2516: cursor get_rslt_ovn_c is
2517: select object_version_number,
2518: sspndd_flag
2519: from ben_prtt_enrt_rslt_f
2520: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
2521: and business_group_id = p_business_group_id
2522: and p_effective_date
2523: between effective_start_date and effective_end_date;