[Home] [Help]
126: exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
127: ben_prtn_elig_prfl_f cep
128: where epa.'||p_col_name||' = :4 and epa.prtn_elig_id = cep.prtn_elig_id and
129: cep.eligy_prfl_id = ecp.eligy_prfl_id) or
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,
156: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
157: ben_prtn_elig_prfl_f cep
158: where epa.'||p_col_name||' = :4 and epa.prtn_elig_id = cep.prtn_elig_id and
159: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,
257: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
258: ben_prtn_elig_prfl_f cep
259: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
260: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,
287: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
288: ben_prtn_elig_prfl_f cep
289: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
290: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,
317: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
318: ben_prtn_elig_prfl_f cep
319: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
320: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,
347: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
348: ben_prtn_elig_prfl_f cep
349: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
350: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,
377: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
378: ben_prtn_elig_prfl_f cep
379: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
380: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
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,