APPS.BEN_PERSON_DELETE dependencies on BEN_LER_F

Line 2199: --,ben_ler_f ler

2195: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.
2196: CURSOR c1 IS
2197: SELECT DISTINCT benefit_action_id
2198: FROM ben_benefit_actions bba
2199: --,ben_ler_f ler
2200: WHERE person_id = p_person_id
2201: and ( (p_per_in_ler_id is not NULL and MODE_CD = 'U') or (p_per_in_ler_id is NULL) );
2202: /* bba.ler_id = ler.ler_id
2203: and ler.typ_cd = 'SCHEDDU'

Line 2618: FROM ben_ptnl_ler_for_per ptnl,ben_ler_f ler

2614: CURSOR c45 (
2615: p_person_id NUMBER
2616: ) IS
2617: SELECT ptnl_ler_for_per_id
2618: FROM ben_ptnl_ler_for_per ptnl,ben_ler_f ler
2619: WHERE person_id = p_person_id
2620: and ler.ler_id = ptnl.ler_id
2621: and ( (p_per_in_ler_id is not NULL and ler.typ_cd = 'SCHEDDU') or (p_per_in_ler_id is NULL) )
2622: and trunc(sysdate) between ler.effective_start_date and ler.effective_end_date

Line 3137: ben_ler_f ler

3133: p_effective_date date
3134: ) is
3135: SELECT 'Y'
3136: FROM ben_per_in_ler pil,
3137: ben_ler_f ler
3138: WHERE pil.person_id = p_person_id
3139: AND pil.per_in_ler_stat_cd = 'STRTD'
3140: AND pil.ler_id = ler.ler_id
3141: AND pil.business_group_id = ler.business_group_id

Line 3153: ben_ler_f ler

3149: p_effective_date date
3150: ) is
3151: SELECT 'Y'
3152: FROM ben_prtt_enrt_rslt_f pen,
3153: ben_ler_f ler
3154: WHERE pen.person_id=p_person_id and
3155: pen.prtt_enrt_rslt_stat_cd is null and
3156: -- pen.sspndd_flag='N' and Needs to resolve suspended record also
3157: pen.effective_end_date = hr_api.g_eot and

Line 3174: ben_ler_f ler

3170: ) is
3171: SELECT 'Y'
3172: FROM ben_prtt_rt_val prv,
3173: ben_prtt_enrt_rslt_f pen,
3174: ben_ler_f ler
3175: WHERE
3176: pen.person_id=p_person_id and
3177: prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3178: pen.prtt_enrt_rslt_stat_cd is null and

Line 3196: ben_ler_f ler,

3192: ) is
3193: SELECT 'Y'
3194: FROM ben_elig_cvrd_dpnt_f ecd,
3195: ben_per_in_ler pil,
3196: ben_ler_f ler,
3197: ben_prtt_enrt_rslt_f pen
3198: WHERE
3199: pil.person_id=p_person_id and
3200: pil.per_in_ler_id = ecd.per_in_ler_id and

Line 3220: ben_ler_f ler,

3216: ) is
3217: SELECT 'Y'
3218: FROM ben_elig_cvrd_dpnt_f ecd,
3219: ben_per_in_ler pil,
3220: ben_ler_f ler,
3221: ben_prtt_enrt_rslt_f pen
3222: WHERE
3223: ecd.dpnt_person_id = p_person_id and
3224: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and

Line 3243: ben_ler_f ler,

3239: ) is
3240: SELECT 'Y'
3241: FROM ben_pl_bnf_f pbn,
3242: ben_per_in_ler pil,
3243: ben_ler_f ler,
3244: ben_prtt_enrt_rslt_f pen
3245: WHERE
3246: pbn.bnf_person_id = p_person_id and
3247: p_effective_date between pbn.dsgn_strt_dt and pbn.dsgn_thru_dt and

Line 3377: ben_per_in_ler pil, ben_ler_f ler,

3373:
3374: cursor c_chk_ele_entries is
3375: select '1' from
3376: ben_prtt_enrt_rslt_f pen,
3377: ben_per_in_ler pil, ben_ler_f ler,
3378: ben_prtt_rt_val prv
3379: where pen.person_id = p_person_id
3380: and pen.business_group_id = p_business_group_id
3381: and pen.per_in_ler_id = pil.per_in_ler_id

Line 3416: ben_ler_f ler,

3412: ele.effective_start_date esd
3413: from
3414: ben_prtt_enrt_rslt_f pen,
3415: ben_per_in_ler pil,
3416: ben_ler_f ler,
3417: ben_prtt_rt_val prv,
3418: pay_element_entry_values_f elv,
3419: pay_element_entries_f ele
3420: where pen.person_id = p_person_id

Line 3440: ben_ler_f ler

3436:
3437: cursor c_get_pil is
3438: select pil.per_in_ler_id
3439: from ben_per_in_ler pil,
3440: ben_ler_f ler
3441: where pil.ler_id = ler.ler_id
3442: and l_effective_date between ler.effective_start_date and ler.effective_end_date
3443: and pil.person_id = p_person_id
3444: and ler.business_group_id = p_business_group_id