DBA Data[Home] [Help]

APPS.BEN_COMP_OBJ_FILTER dependencies on BEN_ENRT_PERD

Line 887: ben_enrt_perd enp

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
891: and pet.effective_end_date

Line 897: from ben_enrt_perd enp1

893: enp.popl_enrt_typ_cycl_id
894: -- PB : 5422 :
895: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt
896: /* 5422 : PB :and enp.strt_dt = (select enp1.strt_dt
897: from ben_enrt_perd enp1
898: where enp1.enrt_perd_id
899: = p_popl_enrt_typ_cycl_id) */
900: and enp.business_group_id =
901: pet.business_group_id

Line 912: ben_enrt_perd enp

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
916: between pet.effective_start_date

Line 923: from ben_enrt_perd enp1

919: enp.popl_enrt_typ_cycl_id
920: -- PB : 5422 :
921: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt
922: /* and enp.strt_dt = (select enp1.strt_dt
923: from ben_enrt_perd enp1
924: where enp1.enrt_perd_id
925: = p_popl_enrt_typ_cycl_id) */
926: and enp.business_group_id =
927: pet.business_group_id