APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 3142: FROM ben_popl_enrt_typ_cycl_f petc,

3138: enrtp.hrchy_to_use_cd,
3139: enrtp.pos_structure_version_id,
3140: /* bug 2746865 */
3141: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3142: FROM ben_popl_enrt_typ_cycl_f petc,
3143: ben_enrt_perd enrtp,
3144: ben_ler_f ler
3145: WHERE petc.pl_id = l_pl_id
3146: AND petc.business_group_id = p_business_group_id

Line 3181: FROM ben_popl_enrt_typ_cycl_f petc,

3177: enrtp.hrchy_to_use_cd,
3178: enrtp.pos_structure_version_id,
3179: /* bug 2746865*/
3180: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3181: FROM ben_popl_enrt_typ_cycl_f petc,
3182: ben_enrt_perd enrtp,
3183: ben_ler_f ler
3184: WHERE petc.pgm_id = p_pgm_id
3185: AND petc.business_group_id = p_business_group_id

Line 3220: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3216: leer.enrt_perd_strt_days,
3217: leer.enrt_perd_end_days,
3218: /* bug 2746865*/
3219: leer.enrt_perd_det_ovrlp_bckdt_cd
3220: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3221: WHERE leer.ler_id = p_ler_id
3222: AND leer.business_group_id = p_business_group_id
3223: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3224: AND leer.effective_end_date

Line 3250: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

3246: leer.enrt_perd_strt_days,
3247: leer.enrt_perd_end_days,
3248: /* bug 2746865*/
3249: leer.enrt_perd_det_ovrlp_bckdt_cd
3250: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
3251: WHERE leer.ler_id = p_ler_id
3252: AND leer.business_group_id = p_business_group_id
3253: AND l_lf_evt_ocrd_dt BETWEEN leer.effective_start_date
3254: AND leer.effective_end_date