[Home] [Help]
135: exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
136: ben_prtn_elig_prfl_f cep
137: where epa.'||p_col_name||'= :5 and epa.prtn_elig_id = cep.prtn_elig_id and
138: cep.eligy_prfl_id = ecl.eligy_prfl_id) or
139: exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
140: ben_prtn_elig_prfl_f cep
141: where epa.'||p_col_name||'= :6 and epa.prtn_elig_id = cep.prtn_elig_id and
142: cep.eligy_prfl_id = ehw.eligy_prfl_id) or
143: exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
165: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
166: ben_prtn_elig_prfl_f cep
167: where epa.'||p_col_name||'= :5 and epa.prtn_elig_id = cep.prtn_elig_id and
168: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
169: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
170: ben_prtn_elig_prfl_f cep
171: where epa.'||p_col_name||'= :6 and epa.prtn_elig_id = cep.prtn_elig_id and
172: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
173: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
266: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
267: ben_prtn_elig_prfl_f cep
268: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
269: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
270: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
271: ben_prtn_elig_prfl_f cep
272: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
273: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
274: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
296: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
297: ben_prtn_elig_prfl_f cep
298: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
299: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
300: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
301: ben_prtn_elig_prfl_f cep
302: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
303: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
304: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
326: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
327: ben_prtn_elig_prfl_f cep
328: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
329: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
330: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
331: ben_prtn_elig_prfl_f cep
332: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
333: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
334: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
356: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
357: ben_prtn_elig_prfl_f cep
358: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
359: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
360: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
361: ben_prtn_elig_prfl_f cep
362: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
363: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
364: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
386: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
387: ben_prtn_elig_prfl_f cep
388: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
389: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
390: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
391: ben_prtn_elig_prfl_f cep
392: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
393: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
394: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,