APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_ELIG_PER_OPT_F

Line 202: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

198: or pil.per_in_ler_stat_cd is null); -- outer join condition
199:
200: cursor c_hrs_wkd_opt is
201: select epo.rt_hrs_wkd_val
202: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
203: ben_per_in_ler pil
204: where bep.person_id = p_person_id
205: and bep.elig_per_id = epo.elig_per_id
206: and epo.opt_id = p_opt_id

Line 220: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

216: or pil.per_in_ler_stat_cd is null); -- outer join condition
217:
218: cursor c_hrs_wkd_plip is
219: select epo.rt_hrs_wkd_val
220: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
221: ben_per_in_ler pil
222: where bep.person_id = p_person_id
223: and bep.elig_per_id = epo.elig_per_id
224: and epo.opt_id = p_opt_id

Line 299: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

295: );
296:
297: cursor c_pct_ft_opt is
298: select epo.rt_pct_fl_tm_val
299: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
300: ben_per_in_ler pil
301: where bep.person_id = p_person_id
302: and bep.elig_per_id = epo.elig_per_id
303: and epo.opt_id = p_opt_id

Line 317: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

313: or pil.per_in_ler_stat_cd is null); -- outer join condition
314:
315: cursor c_pct_ft_plip is
316: select epo.rt_pct_fl_tm_val
317: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
318: ben_per_in_ler pil
319: where bep.person_id = p_person_id
320: and bep.elig_per_id = epo.elig_per_id
321: and epo.opt_id = p_opt_id