APPS.BEN_PEP_CACHE1 dependencies on BEN_ELIG_PER_F

Line 53: from ben_elig_per_f pep,

49: )
50: is
51: select /*+ benppch1.get_curroiplippep_dets.c_piloiplip_dets */
52: pep.elig_per_id
53: from ben_elig_per_f pep,
54: ben_per_in_ler pil
55: where pep.person_id = c_person_id
56: and pep.pgm_id = c_pgm_id
57: and pep.plip_id = c_plip_id

Line 72: from ben_elig_per_f pep

68: )
69: is
70: select /*+ benppch1.get_curroiplippep_dets.c_nopiloiplip_dets */
71: pep.elig_per_id
72: from ben_elig_per_f pep
73: where pep.person_id = c_person_id
74: and pep.per_in_ler_id is null
75: and pep.pgm_id = c_pgm_id
76: and pep.plip_id = c_plip_id

Line 88: from ben_elig_per_f pep,

84: )
85: is
86: select /*+ benppch1.get_curroiplippep_dets.c_piloiplipnip_dets */
87: pep.elig_per_id
88: from ben_elig_per_f pep,
89: ben_per_in_ler pil
90: where pep.person_id = c_person_id
91: and pep.pgm_id is null
92: and pep.plip_id = c_plip_id

Line 106: from ben_elig_per_f pep

102: )
103: is
104: select /*+ benppch1.get_curroiplippep_dets.c_nopiloiplipnip_dets */
105: pep.elig_per_id
106: from ben_elig_per_f pep
107: where pep.person_id = c_person_id
108: and pep.per_in_ler_id is null
109: and pep.pgm_id is null
110: and pep.plip_id = c_plip_id

Line 198: from ben_elig_per_f pep,

194: select /*+ benppch1.get_currplnpep_dets.c_pilpln_dets */
195: pep.elig_per_id,
196: pep.prtn_strt_dt,
197: pep.prtn_end_dt
198: from ben_elig_per_f pep,
199: ben_per_in_ler pil
200: where pep.person_id = c_person_id
201: and pep.pgm_id = c_pgm_id
202: and pep.pl_id = c_pl_id

Line 220: from ben_elig_per_f pep

216: select /*+ benppch1.get_currplnpep_dets.c_nopilpln_dets */
217: pep.elig_per_id,
218: pep.prtn_strt_dt,
219: pep.prtn_end_dt
220: from ben_elig_per_f pep
221: where pep.person_id = c_person_id
222: and pep.per_in_ler_id is null
223: and pep.pgm_id = c_pgm_id
224: and pep.pl_id = c_pl_id

Line 238: from ben_elig_per_f pep,

234: select /*+ benppch1.get_currplnpep_dets.c_pilplnip_dets */
235: pep.elig_per_id,
236: pep.prtn_strt_dt,
237: pep.prtn_end_dt
238: from ben_elig_per_f pep,
239: ben_per_in_ler pil
240: where pep.person_id = c_person_id
241: and pep.pgm_id is null
242: and pep.pl_id = c_pl_id

Line 259: from ben_elig_per_f pep

255: select /*+ benppch1.get_currplnpep_dets.c_nopilplnip_dets */
256: pep.elig_per_id,
257: pep.prtn_strt_dt,
258: pep.prtn_end_dt
259: from ben_elig_per_f pep
260: where pep.person_id = c_person_id
261: and pep.per_in_ler_id is null
262: and pep.pgm_id is null
263: and pep.pl_id = c_pl_id