APPS.BEN_PERSON_DELETE dependencies on HR_API

Line 3019: pen.effective_end_date = hr_api.g_eot and

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
3020: p_effective_date between pen.enrt_cvg_strt_dt and
3021: pen.enrt_cvg_thru_dt
3022: and ler.ler_id=pen.ler_id
3023: AND pen.business_group_id = ler.business_group_id

Line 3065: ecd.effective_end_date = hr_api.g_eot

3061: pil.person_id=p_person_id and
3062: pil.per_in_ler_id = ecd.per_in_ler_id and
3063: pil.business_group_id = ecd.business_group_id and
3064: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and
3065: ecd.effective_end_date = hr_api.g_eot
3066: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3067: pen.prtt_enrt_rslt_stat_cd is null
3068: AND pil.ler_id = ler.ler_id
3069: AND pil.business_group_id = ler.business_group_id

Line 3087: ecd.effective_end_date = hr_api.g_eot

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
3087: ecd.effective_end_date = hr_api.g_eot
3088: and pil.per_in_ler_id = ecd.per_in_ler_id
3089: and pil.business_group_id = ecd.business_group_id
3090: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3091: pen.prtt_enrt_rslt_stat_cd is null

Line 3110: pbn.effective_end_date = hr_api.g_eot

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
3110: pbn.effective_end_date = hr_api.g_eot
3111: and pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3112: pen.prtt_enrt_rslt_stat_cd is null
3113: and pil.per_in_ler_id=pbn.per_in_ler_id
3114: AND pil.business_group_id = pbn.business_group_id