APPS.BEN_PEP_CACHE2 dependencies on BEN_ELIG_PER_F

Line 63: from ben_elig_per_f pep

59: ,c_eff_date date
60: )
61: is
62: select pep.per_in_ler_id
63: from ben_elig_per_f pep
64: where pep.per_in_ler_id = c_pil_id
65: and c_eff_date
66: between pep.effective_start_date and pep.effective_end_date
67: and rownum=1;

Line 254: from ben_elig_per_f tab1

250: tab1.prtn_end_dt,
251: tab1.object_version_number,
252: tab1.elig_per_id,
253: tab1.per_in_ler_id
254: from ben_elig_per_f tab1
255: where tab1.per_in_ler_id = c_pil_id
256: and c_effective_date
257: between tab1.effective_start_date and tab1.effective_end_date
258: order by tab1.pgm_id, tab1.pl_id, tab1.plip_id;

Line 311: from ben_elig_per_f tab1

307: tab1.prtn_end_dt,
308: tab1.object_version_number,
309: tab1.elig_per_id,
310: tab1.per_in_ler_id
311: from ben_elig_per_f tab1
312: where tab1.per_in_ler_id is null
313: and tab1.person_id = c_person_id
314: and c_effective_date
315: between tab1.effective_start_date and tab1.effective_end_date

Line 720: ben_elig_per_f tab2,

716: ,tab2.prtn_strt_dt pep_psd
717: ,tab2.prtn_end_dt pep_ped
718: ,tab3.per_in_ler_stat_cd
719: from ben_elig_per_opt_f tab1,
720: ben_elig_per_f tab2,
721: ben_per_in_ler tab3
722: where tab1.opt_id is not null
723: and tab1.elig_per_id = tab2.elig_per_id
724: and tab3.per_in_ler_id = tab1.per_in_ler_id

Line 788: ben_elig_per_f tab2

784: ,tab2.per_in_ler_id
785: ,tab2.prtn_strt_dt pep_psd
786: ,tab2.prtn_end_dt pep_ped
787: from ben_elig_per_opt_f tab1,
788: ben_elig_per_f tab2
789: where tab2.per_in_ler_id is null
790: and tab2.person_id = c_person_id
791: and tab1.opt_id is not null
792: and tab1.elig_per_id = tab2.elig_per_id