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 1796: ,ben_per_in_ler pil

1792: is
1793: select epe.elig_per_elctbl_chc_id
1794: from ben_elig_per_elctbl_chc epe
1795: ,ben_oipl_f oipl
1796: ,ben_per_in_ler pil
1797: where epe.per_in_ler_id = pil.per_in_ler_id
1798: and nvl(epe.pgm_id, -1) = nvl(p_pgm_id, -1)
1799: and epe.pl_id = p_pl_id
1800: and epe.pl_id = oipl.pl_id(+)

Line 3050: from ben_per_in_ler pil,

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

Line 3118: ben_per_in_ler pil,

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

Line 7335: from ben_per_in_ler pil,

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

Line 8796: ben_per_in_ler pil,

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

Line 8833: ben_per_in_ler pil,

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

Line 8898: from ben_peR_in_ler pil,

8894: --------Bug 7687104
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