APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 3188: FROM ben_popl_enrt_typ_cycl_f petc,

3184: enrtp.hrchy_to_use_cd,
3185: enrtp.pos_structure_version_id,
3186: /* bug 2746865 */
3187: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3188: FROM ben_popl_enrt_typ_cycl_f petc,
3189: ben_enrt_perd enrtp,
3190: ben_ler_f ler
3191: WHERE petc.pl_id = l_pl_id
3192: AND petc.business_group_id = p_business_group_id

Line 3227: FROM ben_popl_enrt_typ_cycl_f petc,

3223: enrtp.hrchy_to_use_cd,
3224: enrtp.pos_structure_version_id,
3225: /* bug 2746865*/
3226: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3227: FROM ben_popl_enrt_typ_cycl_f petc,
3228: ben_enrt_perd enrtp,
3229: ben_ler_f ler
3230: WHERE petc.pgm_id = p_pgm_id
3231: AND petc.business_group_id = p_business_group_id

Line 3266: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3262: leer.enrt_perd_strt_days,
3263: leer.enrt_perd_end_days,
3264: /* bug 2746865*/
3265: leer.enrt_perd_det_ovrlp_bckdt_cd
3266: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3267: WHERE leer.ler_id = p_ler_id
3268: AND leer.business_group_id = p_business_group_id
3269: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3270: AND leer.effective_end_date

Line 3296: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3292: leer.enrt_perd_strt_days,
3293: leer.enrt_perd_end_days,
3294: /* bug 2746865*/
3295: leer.enrt_perd_det_ovrlp_bckdt_cd
3296: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3297: WHERE leer.ler_id = p_ler_id
3298: AND leer.business_group_id = p_business_group_id
3299: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3300: AND leer.effective_end_date