DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 616: ben_popl_enrt_typ_cycl_f petc

612: -- Bug 2386000
613: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number ) IS
614: SELECT leer.lee_rsn_id
615: FROM ben_lee_rsn_f leer,
616: ben_popl_enrt_typ_cycl_f petc
617: WHERE leer.ler_id = c_ler_id
618: AND leer.business_group_id = p_business_group_id
619: AND p_effective_date BETWEEN leer.effective_start_date
620: AND leer.effective_end_date

Line 631: ben_popl_enrt_typ_cycl_f petc

627: --
628: CURSOR c_lee_rsn_for_program (c_ler_id number, c_pgm_id number )IS
629: SELECT leer.lee_rsn_id
630: FROM ben_lee_rsn_f leer,
631: ben_popl_enrt_typ_cycl_f petc
632: WHERE leer.ler_id = c_ler_id
633: AND leer.business_group_id = p_business_group_id
634: AND p_effective_date BETWEEN leer.effective_start_date
635: AND leer.effective_end_date