eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on BEN_LER_F

Line 2097: ben_ler_f ler

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
2101: and pler.per_in_ler_stat_cd = 'STRTD'

Line 2309: ben_ler_f ler,

2305: cqb.cbr_elig_perd_strt_dt strt_dt,
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'

Line 2728: ben_ler_f l

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
2732: and a.cm_typ_id = e.cm_typ_id

Line 2853: ben_ler_f l

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
2857: between l.effective_start_date and l.effective_end_date

Line 3035: ben_ler_f ler ,

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
3039: and pil.ler_id = ler.ler_id