APPS.BEN_ELEMENT_ENTRY dependencies on BEN_PER_IN_LER

Line 443: ben_per_in_ler pil,

439: cursor c_abs_att is
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

Line 2919: from ben_per_in_ler pil,

2915: pil.lf_evt_ocrd_dt,
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

Line 2984: ben_per_in_ler pil,

2980: )
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

Line 6774: from ben_per_in_ler pil,

6770: c_effective_date date) is
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'

Line 8197: ben_per_in_ler pil,

8193: pil.trgr_table_pk_id,
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)

Line 8234: ben_per_in_ler pil,

8230: )
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