[Home] [Help]
127: exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
128: ben_prtn_elig_prfl_f cep
129: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
130: cep.eligy_prfl_id = eap.eligy_prfl_id) or
131: exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
132: ben_prtn_elig_prfl_f cep
133: where epa.'||p_col_name||' = :4 and epa.prtn_elig_id = cep.prtn_elig_id and
134: cep.eligy_prfl_id = ecp.eligy_prfl_id) or
135: exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
157: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
158: ben_prtn_elig_prfl_f cep
159: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
160: cep.eligy_prfl_id = eap.eligy_prfl_id) and
161: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
162: ben_prtn_elig_prfl_f cep
163: where epa.'||p_col_name||' = :4 and epa.prtn_elig_id = cep.prtn_elig_id and
164: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
165: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
258: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
259: ben_prtn_elig_prfl_f cep
260: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
261: cep.eligy_prfl_id = eap.eligy_prfl_id) and
262: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
263: ben_prtn_elig_prfl_f cep
264: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
265: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
266: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
288: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
289: ben_prtn_elig_prfl_f cep
290: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
291: cep.eligy_prfl_id = eap.eligy_prfl_id) and
292: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
293: ben_prtn_elig_prfl_f cep
294: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
295: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
296: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
318: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
319: ben_prtn_elig_prfl_f cep
320: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
321: cep.eligy_prfl_id = eap.eligy_prfl_id) and
322: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
323: ben_prtn_elig_prfl_f cep
324: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
325: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
326: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
348: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
349: ben_prtn_elig_prfl_f cep
350: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
351: cep.eligy_prfl_id = eap.eligy_prfl_id) and
352: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
353: ben_prtn_elig_prfl_f cep
354: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
355: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
356: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,
378: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
379: ben_prtn_elig_prfl_f cep
380: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
381: cep.eligy_prfl_id = eap.eligy_prfl_id) and
382: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
383: ben_prtn_elig_prfl_f cep
384: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
385: cep.eligy_prfl_id = ecp.eligy_prfl_id) and
386: not exists (select null from ben_elig_comp_lvl_prte_f ecl, ben_prtn_elig_f epa,