eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_COMP_OBJ_FILTER dependencies on BEN_LEE_RSN_F

Line 592: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

588: is
589: select 1 ordr_num ,
590: leer.lee_rsn_id,
591: NVL(leer.defer_deenrol_flag,'N')
592: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
593: WHERE leer.ler_id = p_ler_id
594: AND leer.business_group_id = p_business_group_id
595: AND c_effective_date BETWEEN leer.effective_start_date
596: AND leer.effective_end_date

Line 607: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

603: UNION
604: select 2 ordr_num ,
605: leer.lee_rsn_id,
606: NVL(leer.defer_deenrol_flag,'N')
607: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
608: WHERE leer.ler_id = p_ler_id
609: AND leer.business_group_id = p_business_group_id
610: AND c_effective_date BETWEEN leer.effective_start_date
611: AND leer.effective_end_date

Line 845: FROM ben_lee_rsn_f leer,

841: -- 12715758
842: -- Changed p_effective_date to l_effective_date in the below cursors
843: cursor c_lee_rsn_rl_pgm is
844: select formula_id
845: FROM ben_lee_rsn_f leer,
846: ben_popl_enrt_typ_cycl_f petc,
847: ben_lee_rsn_rl_f lrr
848: WHERE leer.ler_id = p_ler_id
849: AND l_effective_date BETWEEN leer.effective_start_date -- 12715758

Line 866: FROM ben_lee_rsn_f leer,

862: -- bug - 4644355 - changed pgm_id to pl_id below
863: --
864: cursor c_lee_rsn_rl_plnip is
865: select formula_id
866: FROM ben_lee_rsn_f leer,
867: ben_popl_enrt_typ_cycl_f petc,
868: ben_lee_rsn_rl_f lrr
869: WHERE leer.ler_id = p_ler_id
870: AND l_effective_date BETWEEN leer.effective_start_date -- 12715758