DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_LEE_RSN_F

Line 616: FROM ben_lee_rsn_f leer,

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

Line 631: FROM ben_lee_rsn_f leer,

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