DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 571: ben_popl_enrt_typ_cycl_f pop

567: lee.enrt_perd_strt_dt_cd,
568: lee.enrt_perd_strt_dt_rl,
569: lee.enrt_perd_strt_days
570: from ben_lee_rsn_f lee,
571: ben_popl_enrt_typ_cycl_f pop
572: where pop.pl_id = p_pl_id
573: and pop.business_group_id +0 = p_business_group_id
574: and p_effective_date
575: between pop.effective_start_date

Line 590: FROM ben_popl_enrt_typ_cycl_f petc,

586: CURSOR c_sched_enrol_period_for_plan(p_pl_id number,
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

Line 611: FROM ben_popl_enrt_typ_cycl_f petc,

607: CURSOR c_sched_enrol_period_for_pgm(p_pgm_id number,
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

Line 631: ben_popl_enrt_typ_cycl_f pop

627: lee.enrt_perd_strt_dt_cd,
628: lee.enrt_perd_strt_dt_rl,
629: lee.enrt_perd_strt_days
630: from ben_lee_rsn_f lee,
631: ben_popl_enrt_typ_cycl_f pop
632: where pop.pgm_id = p_pgm_id
633: and pop.business_group_id +0 = p_business_group_id
634: and p_effective_date
635: between pop.effective_start_date