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 2096: ben_per_in_ler pler,

2092: , ler.ler_attribute8
2093: , ler.ler_attribute9
2094: , ler.ler_attribute10
2095: from
2096: ben_per_in_ler pler,
2097: ben_ler_f ler
2098: where
2099: pler.person_id = p_person_id
2100: and pler.ler_id = ler.ler_id

Line 2310: ben_per_in_ler pil

2306: cqb.cbr_elig_perd_end_dt end_dt
2307: from ben_cbr_quald_bnf cqb,
2308: ben_cbr_per_in_ler cpl,
2309: ben_ler_f ler,
2310: ben_per_in_ler pil
2311: where
2312: cqb.quald_bnf_person_id = p_person_id
2313: and quald_bnf_flag = 'Y'
2314: and p_effective_date between nvl(cqb.cbr_elig_perd_strt_dt,p_effective_date)

Line 2727: ben_per_in_ler p,

2723: ben_per_cm_prvdd_f b,
2724: ben_per_cm_trgr_f c,
2725: ben_cm_trgr d,
2726: ben_cm_typ_f e,
2727: ben_per_in_ler p,
2728: ben_ler_f l
2729: where
2730: a.person_id = p_person_id
2731: and a.per_cm_id = b.per_cm_id

Line 2852: from ben_per_in_ler p,

2848: ,l.name
2849: ,p.per_in_ler_stat_cd
2850: ,p.lf_evt_ocrd_dt
2851: ,p.ntfn_dt
2852: from ben_per_in_ler p,
2853: ben_ler_f l
2854: where p_per_in_ler_id = p.per_in_ler_id
2855: and p.ler_id = l.ler_id
2856: and p_effective_date

Line 3034: ben_per_in_ler pil ,

3030: ,pl.PERF_REVW_STRT_DT
3031: ,pl.EMP_INTERVIEW_TYP_CD
3032: ,pl.ASG_UPDT_EFF_DATE
3033: from ben_cwb_person_info cpi ,
3034: ben_per_in_ler pil ,
3035: ben_ler_f ler ,
3036: ben_cwb_pl_dsgn pl
3037: where cpi.person_id = p_person_id
3038: and cpi.group_per_in_ler_id = pil.per_in_ler_id

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

4495: open c_hr_lkup('BEN_CWB_QUAR_IN_GRD', l_cwb.GRD_QUARTILE) ;
4496: fetch c_hr_lkup into g_CWB_Person_Grade_QUARTILE ;
4497: close c_hr_lkup ;
4498:
4499: open c_hr_lkup('BEN_PER_IN_LER_STAT', l_cwb.PER_IN_LER_STAT_CD) ;
4500: fetch c_hr_lkup into g_CWB_Life_Event_status ;
4501: close c_hr_lkup ;
4502:
4503: open c_pln (g_cwb_per_group_pl_id , g_CWB_Life_Event_Occurred_Date );