209: or pil.per_in_ler_stat_cd is null); -- outer join condition
210:
211: cursor c_hrs_wkd_opt is
212: select epo.rt_hrs_wkd_val
213: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
214: ben_per_in_ler pil
215: where bep.person_id = p_person_id
216: and bep.elig_per_id = epo.elig_per_id
217: and epo.opt_id = p_opt_id
227: or pil.per_in_ler_stat_cd is null); -- outer join condition
228:
229: cursor c_hrs_wkd_plip is
230: select epo.rt_hrs_wkd_val
231: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
232: ben_per_in_ler pil
233: where bep.person_id = p_person_id
234: and bep.elig_per_id = epo.elig_per_id
235: and epo.opt_id = p_opt_id
306: );
307:
308: cursor c_pct_ft_opt is
309: select epo.rt_pct_fl_tm_val
310: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
311: ben_per_in_ler pil
312: where bep.person_id = p_person_id
313: and bep.elig_per_id = epo.elig_per_id
314: and epo.opt_id = p_opt_id
324: or pil.per_in_ler_stat_cd is null); -- outer join condition
325:
326: cursor c_pct_ft_plip is
327: select epo.rt_pct_fl_tm_val
328: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
329: ben_per_in_ler pil
330: where bep.person_id = p_person_id
331: and bep.elig_per_id = epo.elig_per_id
332: and epo.opt_id = p_opt_id