DBA Data[Home] [Help]

APPS.BEN_COMP_OBJ_FILTER dependencies on BEN_ENRT_PERD

Line 620: ben_enrt_perd enp

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

Line 630: from ben_enrt_perd enp1

626: enp.popl_enrt_typ_cycl_id
627: -- PB : 5422 :
628: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt
629: /* 5422 : PB :and enp.strt_dt = (select enp1.strt_dt
630: from ben_enrt_perd enp1
631: where enp1.enrt_perd_id
632: = p_popl_enrt_typ_cycl_id) */
633: and enp.business_group_id =
634: pet.business_group_id

Line 645: ben_enrt_perd enp

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

Line 656: from ben_enrt_perd enp1

652: enp.popl_enrt_typ_cycl_id
653: -- PB : 5422 :
654: and enp.asnd_lf_evt_dt = p_lf_evt_ocrd_dt
655: /* and enp.strt_dt = (select enp1.strt_dt
656: from ben_enrt_perd enp1
657: where enp1.enrt_perd_id
658: = p_popl_enrt_typ_cycl_id) */
659: and enp.business_group_id =
660: pet.business_group_id