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_ELEMENT_ENTRY dependencies on BEN_LER_F

Line 444: ben_ler_f ler

440: select
441: aba.*, pil.per_in_ler_id
442: from per_absence_attendances aba,
443: ben_per_in_ler pil,
444: ben_ler_f ler
445: where aba.person_id = p_person_id
446: and pil.person_id = p_person_id
447: and aba.absence_attendance_id = pil.trgr_table_pk_id
448: and pil.ler_id = ler.ler_id

Line 3051: ben_ler_f ler

3047: pil.trgr_table_pk_id,
3048: ler.ler_id,
3049: ler.typ_cd
3050: from ben_per_in_ler pil,
3051: ben_ler_f ler
3052: where pil.per_in_ler_id = c_per_in_ler_id
3053: and ler.ler_id = pil.ler_id
3054: and c_effective_date between
3055: ler.effective_start_date and ler.effective_end_date;

Line 3119: ben_ler_f ler

3115: is
3116: select ler.name name, ler.ler_id ler_id
3117: from ben_prtt_rt_val prv,
3118: ben_per_in_ler pil,
3119: ben_ler_f ler
3120: where prv.per_in_ler_id = pil.per_in_ler_id
3121: and pil.ler_id = ler.ler_id
3122: and prv.prtt_rt_val_id = p_prtt_rt_val_id
3123: and prv.rt_strt_dt = p_rt_start_date;

Line 7336: ben_ler_f ler

7332: select pil.per_in_ler_id,
7333: pil.trgr_table_pk_id,
7334: ler.ler_id
7335: from ben_per_in_ler pil,
7336: ben_ler_f ler
7337: where pil.per_in_ler_id = c_per_in_ler_id
7338: and ler.ler_id = pil.ler_id
7339: and ler.typ_cd ='ABS'
7340: and c_effective_date between

Line 8797: ben_ler_f ler

8793: pil.per_in_ler_id,
8794: ler.ler_id
8795: from ben_prtt_rt_val prt,
8796: ben_per_in_ler pil,
8797: ben_ler_f ler
8798: where prt.prtt_rt_val_id = c_prtt_rt_val_id
8799: -- ended_per_in_ler_id may be null in case of back out
8800: and pil.per_in_ler_id = nvl(prt.ended_per_in_ler_id,prt.per_in_ler_id)
8801: and ler.ler_id = pil.ler_id

Line 8834: ben_ler_f ler

8830: is
8831: select ler.name name, ler.ler_id ler_id
8832: from ben_prtt_rt_val prv,
8833: ben_per_in_ler pil,
8834: ben_ler_f ler
8835: where prv.per_in_ler_id = pil.per_in_ler_id
8836: and pil.ler_id = ler.ler_id
8837: and prv.prtt_rt_val_id = p_prtt_rt_val_id
8838: and prv.rt_end_dt = p_rt_end_date;

Line 8899: ben_ler_f ler

8895: --------------------Bug 9235544
8896: cursor c_current_pil is
8897: select pil.*
8898: from ben_peR_in_ler pil,
8899: ben_ler_f ler
8900: where pil.procd_dt is null
8901: and pil.business_group_id = p_business_group_id
8902: and pil.person_id = p_person_id
8903: and pil.per_in_ler_stat_cd = 'STRTD'