DBA Data[Home] [Help]

APPS.BEN_COMP_OBJ_FILTER dependencies on BEN_LEE_RSN_F

Line 578: FROM ben_lee_rsn_f leer,

574: l_failed_rule boolean;
575: --
576: cursor c_lee_rsn_rl_pgm is
577: select formula_id
578: FROM ben_lee_rsn_f leer,
579: ben_popl_enrt_typ_cycl_f petc,
580: ben_lee_rsn_rl_f lrr
581: WHERE leer.ler_id = p_ler_id
582: AND p_effective_date BETWEEN leer.effective_start_date

Line 599: FROM ben_lee_rsn_f leer,

595: -- bug - 4644355 - changed pgm_id to pl_id below
596: --
597: cursor c_lee_rsn_rl_plnip is
598: select formula_id
599: FROM ben_lee_rsn_f leer,
600: ben_popl_enrt_typ_cycl_f petc,
601: ben_lee_rsn_rl_f lrr
602: WHERE leer.ler_id = p_ler_id
603: AND p_effective_date BETWEEN leer.effective_start_date