DBA Data[Home] [Help]

APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 573: ben_popl_enrt_typ_cycl_f pop

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

Line 592: FROM ben_popl_enrt_typ_cycl_f petc,

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

Line 613: FROM ben_popl_enrt_typ_cycl_f petc,

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

Line 633: ben_popl_enrt_typ_cycl_f pop

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