DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_ENRT_PERD

Line 591: ben_enrt_perd enrtp

587: p_lf_evt_ocrd_dt date) IS
588: SELECT enrtp.enrt_perd_id,
589: enrtp.strt_dt
590: FROM ben_popl_enrt_typ_cycl_f petc,
591: ben_enrt_perd enrtp
592: WHERE petc.pl_id = p_pl_id
593: AND petc.business_group_id = p_business_group_id
594: AND p_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
595: AND petc.effective_end_date

Line 612: ben_enrt_perd enrtp

608: p_lf_evt_ocrd_dt date) IS
609: SELECT enrtp.enrt_perd_id,
610: enrtp.strt_dt
611: FROM ben_popl_enrt_typ_cycl_f petc,
612: ben_enrt_perd enrtp
613: WHERE petc.pgm_id = p_pgm_id
614: AND petc.business_group_id = p_business_group_id
615: AND p_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
616: AND petc.effective_end_date