[Home] [Help]
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,
139: ben_prtn_elig_prfl_f cep
140: where epa.'||p_col_name||'= :7 and epa.prtn_elig_id = cep.prtn_elig_id and
141: cep.eligy_prfl_id = els.eligy_prfl_id) or
142: exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
169: ben_prtn_elig_prfl_f cep
170: where epa.'||p_col_name||'= :7 and epa.prtn_elig_id = cep.prtn_elig_id and
171: cep.eligy_prfl_id = els.eligy_prfl_id) and
172: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
270: ben_prtn_elig_prfl_f cep
271: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
272: cep.eligy_prfl_id = els.eligy_prfl_id) and
273: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
300: ben_prtn_elig_prfl_f cep
301: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
302: cep.eligy_prfl_id = els.eligy_prfl_id) and
303: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
330: ben_prtn_elig_prfl_f cep
331: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
332: cep.eligy_prfl_id = els.eligy_prfl_id) and
333: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
360: ben_prtn_elig_prfl_f cep
361: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
362: cep.eligy_prfl_id = els.eligy_prfl_id) and
363: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
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,
390: ben_prtn_elig_prfl_f cep
391: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
392: cep.eligy_prfl_id = els.eligy_prfl_id) and
393: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,