APPS.BEN_PERSON_DELETE dependencies on BEN_LER_F

Line 2999: ben_ler_f ler

2995: p_effective_date date
2996: ) is
2997: SELECT 'Y'
2998: FROM ben_per_in_ler pil,
2999: ben_ler_f ler
3000: WHERE pil.person_id = p_person_id
3001: AND pil.per_in_ler_stat_cd = 'STRTD'
3002: AND pil.ler_id = ler.ler_id
3003: AND pil.business_group_id = ler.business_group_id

Line 3015: ben_ler_f ler

3011: p_effective_date date
3012: ) is
3013: SELECT 'Y'
3014: FROM ben_prtt_enrt_rslt_f pen,
3015: ben_ler_f ler
3016: WHERE pen.person_id=p_person_id and
3017: pen.prtt_enrt_rslt_stat_cd is null and
3018: -- pen.sspndd_flag='N' and Needs to resolve suspended record also
3019: pen.effective_end_date = hr_api.g_eot and

Line 3036: ben_ler_f ler

3032: ) is
3033: SELECT 'Y'
3034: FROM ben_prtt_rt_val prv,
3035: ben_prtt_enrt_rslt_f pen,
3036: ben_ler_f ler
3037: WHERE
3038: pen.person_id=p_person_id and
3039: prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3040: pen.prtt_enrt_rslt_stat_cd is null and

Line 3058: ben_ler_f ler,

3054: ) is
3055: SELECT 'Y'
3056: FROM ben_elig_cvrd_dpnt_f ecd,
3057: ben_per_in_ler pil,
3058: ben_ler_f ler,
3059: ben_prtt_enrt_rslt_f pen
3060: WHERE
3061: pil.person_id=p_person_id and
3062: pil.per_in_ler_id = ecd.per_in_ler_id and

Line 3082: ben_ler_f ler,

3078: ) is
3079: SELECT 'Y'
3080: FROM ben_elig_cvrd_dpnt_f ecd,
3081: ben_per_in_ler pil,
3082: ben_ler_f ler,
3083: ben_prtt_enrt_rslt_f pen
3084: WHERE
3085: ecd.dpnt_person_id = p_person_id and
3086: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and

Line 3105: ben_ler_f ler,

3101: ) is
3102: SELECT 'Y'
3103: FROM ben_pl_bnf_f pbn,
3104: ben_per_in_ler pil,
3105: ben_ler_f ler,
3106: ben_prtt_enrt_rslt_f pen
3107: WHERE
3108: pbn.bnf_person_id = p_person_id and
3109: p_effective_date between pbn.dsgn_strt_dt and pbn.dsgn_thru_dt and