DBA Data[Home] [Help]

APPS.BEN_COMP_OBJ_FILTER dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 579: ben_popl_enrt_typ_cycl_f petc,

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
583: AND leer.effective_end_date

Line 600: ben_popl_enrt_typ_cycl_f petc,

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
604: AND leer.effective_end_date

Line 619: ben_popl_enrt_typ_cycl_f pet,

615: --
616: cursor c_schedd_enrt_rl_pgm is
617: select formula_id
618: from ben_schedd_enrt_rl_f lrr,
619: ben_popl_enrt_typ_cycl_f pet,
620: ben_enrt_perd enp
621: where pet.pgm_id = l_pgm_id
622: and p_effective_date
623: between pet.effective_start_date

Line 644: ben_popl_enrt_typ_cycl_f pet,

640: --
641: cursor c_schedd_enrt_rl_plnip is
642: select formula_id
643: from ben_schedd_enrt_rl_f lrr,
644: ben_popl_enrt_typ_cycl_f pet,
645: ben_enrt_perd enp
646: -- CWB changes
647: where pet.pl_id = l_pl_id
648: and p_effective_date