DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_LER_RQRS_ENRT_CTFN_F

Line 355: FROM ben_ler_rqrs_enrt_ctfn_f lre,

351: AND ecf.effective_end_date)
352: OR EXISTS /* Enrollment Certification Required - Plan Life Event */
353: (
354: SELECT 1
355: FROM ben_ler_rqrs_enrt_ctfn_f lre,
356: ben_ler_enrt_ctfn_f lnc
357: WHERE lnc.ler_rqrs_enrt_ctfn_id =
358: lre.ler_rqrs_enrt_ctfn_id
359: AND cv_end_date BETWEEN lnc.effective_start_date

Line 378: ben_ler_rqrs_enrt_ctfn_f lre,

374: OR EXISTS /* Enrollment Certification Required - Option In Plan Life Event */
375: (
376: SELECT 1
377: FROM ben_oipl_f cop,
378: ben_ler_rqrs_enrt_ctfn_f lre,
379: ben_ler_enrt_ctfn_f lnc
380: WHERE cop.pl_id = pln.pl_id
381: AND cop.oipl_id = lre.oipl_id
382: AND lnc.ler_rqrs_enrt_ctfn_id =