[Home] [Help]
130: exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
131: ben_prtn_elig_prfl_f cep
132: where epa.'||p_col_name||'= :5 and epa.prtn_elig_id = cep.prtn_elig_id and
133: cep.eligy_prfl_id = ecl.eligy_prfl_id) or
134: exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
135: ben_prtn_elig_prfl_f cep
136: where epa.'||p_col_name||'= :6 and epa.prtn_elig_id = cep.prtn_elig_id and
137: cep.eligy_prfl_id = ehw.eligy_prfl_id) or
138: exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
160: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
161: ben_prtn_elig_prfl_f cep
162: where epa.'||p_col_name||'= :5 and epa.prtn_elig_id = cep.prtn_elig_id and
163: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
164: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
165: ben_prtn_elig_prfl_f cep
166: where epa.'||p_col_name||'= :6 and epa.prtn_elig_id = cep.prtn_elig_id and
167: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
168: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
261: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
262: ben_prtn_elig_prfl_f cep
263: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
264: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
265: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
266: ben_prtn_elig_prfl_f cep
267: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
268: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
269: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
291: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
292: ben_prtn_elig_prfl_f cep
293: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
294: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
295: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
296: ben_prtn_elig_prfl_f cep
297: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
298: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
299: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
321: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
322: ben_prtn_elig_prfl_f cep
323: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
324: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
325: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
326: ben_prtn_elig_prfl_f cep
327: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
328: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
329: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
351: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
352: ben_prtn_elig_prfl_f cep
353: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
354: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
355: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
356: ben_prtn_elig_prfl_f cep
357: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
358: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
359: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
381: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
382: ben_prtn_elig_prfl_f cep
383: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
384: cep.eligy_prfl_id = ecl.eligy_prfl_id) and
385: not exists (select null from ben_elig_hrs_wkd_prte_f ehw, ben_prtn_elig_f epa,
386: ben_prtn_elig_prfl_f cep
387: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
388: cep.eligy_prfl_id = ehw.eligy_prfl_id) and
389: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,