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 2920: ben_ler_f ler

2916: pil.trgr_table_pk_id,
2917: ler.ler_id,
2918: ler.typ_cd
2919: from ben_per_in_ler pil,
2920: ben_ler_f ler
2921: where pil.per_in_ler_id = c_per_in_ler_id
2922: and ler.ler_id = pil.ler_id
2923: and c_effective_date between
2924: ler.effective_start_date and ler.effective_end_date;

Line 2985: ben_ler_f ler

2981: is
2982: select ler.name name, ler.ler_id ler_id
2983: from ben_prtt_rt_val prv,
2984: ben_per_in_ler pil,
2985: ben_ler_f ler
2986: where prv.per_in_ler_id = pil.per_in_ler_id
2987: and pil.ler_id = ler.ler_id
2988: and prv.prtt_rt_val_id = p_prtt_rt_val_id
2989: and prv.rt_strt_dt = p_rt_start_date;

Line 6775: ben_ler_f ler

6771: select pil.per_in_ler_id,
6772: pil.trgr_table_pk_id,
6773: ler.ler_id
6774: from ben_per_in_ler pil,
6775: ben_ler_f ler
6776: where pil.per_in_ler_id = c_per_in_ler_id
6777: and ler.ler_id = pil.ler_id
6778: and ler.typ_cd ='ABS'
6779: and c_effective_date between

Line 8198: ben_ler_f ler

8194: pil.per_in_ler_id,
8195: ler.ler_id
8196: from ben_prtt_rt_val prt,
8197: ben_per_in_ler pil,
8198: ben_ler_f ler
8199: where prt.prtt_rt_val_id = c_prtt_rt_val_id
8200: -- ended_per_in_ler_id may be null in case of back out
8201: and pil.per_in_ler_id = nvl(prt.ended_per_in_ler_id,prt.per_in_ler_id)
8202: and ler.ler_id = pil.ler_id

Line 8235: ben_ler_f ler

8231: is
8232: select ler.name name, ler.ler_id ler_id
8233: from ben_prtt_rt_val prv,
8234: ben_per_in_ler pil,
8235: ben_ler_f ler
8236: where prv.per_in_ler_id = pil.per_in_ler_id
8237: and pil.ler_id = ler.ler_id
8238: and prv.prtt_rt_val_id = p_prtt_rt_val_id
8239: and prv.rt_end_dt = p_rt_end_date;