DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_LER_ENRT_CTFN_F

Line 356: ben_ler_enrt_ctfn_f lnc

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
360: AND lnc.effective_end_date

Line 379: ben_ler_enrt_ctfn_f lnc

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 =
383: lre.ler_rqrs_enrt_ctfn_id