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_POPL_ENRT_TYP_CYCL_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 846: ben_popl_enrt_typ_cycl_f petc,

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

Line 867: ben_popl_enrt_typ_cycl_f petc,

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

Line 886: ben_popl_enrt_typ_cycl_f pet,

882: --
883: cursor c_schedd_enrt_rl_pgm is
884: select formula_id
885: from ben_schedd_enrt_rl_f lrr,
886: ben_popl_enrt_typ_cycl_f pet,
887: ben_enrt_perd enp
888: where pet.pgm_id = l_pgm_id
889: and l_effective_date -- 12715758
890: between pet.effective_start_date

Line 911: ben_popl_enrt_typ_cycl_f pet,

907: --
908: cursor c_schedd_enrt_rl_plnip is
909: select formula_id
910: from ben_schedd_enrt_rl_f lrr,
911: ben_popl_enrt_typ_cycl_f pet,
912: ben_enrt_perd enp
913: -- CWB changes
914: where pet.pl_id = l_pl_id
915: and l_effective_date -- 12715758