APPS.BEN_EXT_PERSON dependencies on BEN_PER_IN_LER

Line 1386: ,ben_per_in_ler pil

1382: sum(bpl.prvdd_val) credit_provided
1383: , sum(bpl.frftd_val) credit_forfited
1384: , sum(bpl.used_val) credit_used
1385: from ben_prtt_enrt_rslt_f pen
1386: ,ben_per_in_ler pil
1387: ,ben_bnft_prvdd_ldgr_f bpl
1388: ,ben_pl_f pl
1389: where
1390: pen.person_id = p_person_id

Line 2062: ben_per_in_ler pler,

2058: , ler.ler_attribute8
2059: , ler.ler_attribute9
2060: , ler.ler_attribute10
2061: from
2062: ben_per_in_ler pler,
2063: ben_ler_f ler
2064: where
2065: pler.person_id = p_person_id
2066: and pler.ler_id = ler.ler_id

Line 2276: ben_per_in_ler pil

2272: cqb.cbr_elig_perd_end_dt end_dt
2273: from ben_cbr_quald_bnf cqb,
2274: ben_cbr_per_in_ler cpl,
2275: ben_ler_f ler,
2276: ben_per_in_ler pil
2277: where
2278: cqb.quald_bnf_person_id = p_person_id
2279: and quald_bnf_flag = 'Y'
2280: and p_effective_date between nvl(cqb.cbr_elig_perd_strt_dt,p_effective_date)

Line 2693: ben_per_in_ler p,

2689: ben_per_cm_prvdd_f b,
2690: ben_per_cm_trgr_f c,
2691: ben_cm_trgr d,
2692: ben_cm_typ_f e,
2693: ben_per_in_ler p,
2694: ben_ler_f l
2695: where
2696: a.person_id = p_person_id
2697: and a.per_cm_id = b.per_cm_id

Line 2818: from ben_per_in_ler p,

2814: ,l.name
2815: ,p.per_in_ler_stat_cd
2816: ,p.lf_evt_ocrd_dt
2817: ,p.ntfn_dt
2818: from ben_per_in_ler p,
2819: ben_ler_f l
2820: where p_per_in_ler_id = p.per_in_ler_id
2821: and p.ler_id = l.ler_id
2822: and p_effective_date

Line 3000: ben_per_in_ler pil ,

2996: ,pl.PERF_REVW_STRT_DT
2997: ,pl.EMP_INTERVIEW_TYP_CD
2998: ,pl.ASG_UPDT_EFF_DATE
2999: from ben_cwb_person_info cpi ,
3000: ben_per_in_ler pil ,
3001: ben_ler_f ler ,
3002: ben_cwb_pl_dsgn pl
3003: where cpi.person_id = p_person_id
3004: and cpi.group_per_in_ler_id = pil.per_in_ler_id

Line 4464: open c_hr_lkup('BEN_PER_IN_LER_STAT', l_cwb.PER_IN_LER_STAT_CD) ;

4460: open c_hr_lkup('BEN_CWB_QUAR_IN_GRD', l_cwb.GRD_QUARTILE) ;
4461: fetch c_hr_lkup into g_CWB_Person_Grade_QUARTILE ;
4462: close c_hr_lkup ;
4463:
4464: open c_hr_lkup('BEN_PER_IN_LER_STAT', l_cwb.PER_IN_LER_STAT_CD) ;
4465: fetch c_hr_lkup into g_CWB_Life_Event_status ;
4466: close c_hr_lkup ;
4467:
4468: open c_pln (g_cwb_per_group_pl_id , g_CWB_Life_Event_Occurred_Date );