DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_ENRT_CTFN_F

Line 348: FROM ben_enrt_ctfn_f ecf

344: ))
345: OR EXISTS /* Enrollment Certification Required - Plan */
346: (
347: SELECT 1
348: FROM ben_enrt_ctfn_f ecf
349: WHERE ecf.pl_id = pln.pl_id
350: AND cv_end_date BETWEEN ecf.effective_start_date
351: AND ecf.effective_end_date)
352: OR EXISTS /* Enrollment Certification Required - Plan Life Event */

Line 367: FROM ben_oipl_f cop, ben_enrt_ctfn_f ecf

363: AND lre.pl_id = pln.pl_id)
364: OR EXISTS /* Enrollment Certification Required - Option in Plan*/
365: (
366: SELECT 1
367: FROM ben_oipl_f cop, ben_enrt_ctfn_f ecf
368: WHERE ecf.oipl_id = cop.oipl_id
369: AND cv_end_date BETWEEN ecf.effective_start_date
370: AND ecf.effective_end_date
371: AND cv_end_date BETWEEN cop.effective_start_date