[Home] [Help]
122: exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
123: ben_prtn_elig_prfl_f cep
124: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
125: cep.eligy_prfl_id = eap.eligy_prfl_id) or
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,
152: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
153: ben_prtn_elig_prfl_f cep
154: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
155: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,
253: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
254: ben_prtn_elig_prfl_f cep
255: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
256: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,
283: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
284: ben_prtn_elig_prfl_f cep
285: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
286: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,
313: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
314: ben_prtn_elig_prfl_f cep
315: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
316: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,
343: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
344: ben_prtn_elig_prfl_f cep
345: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
346: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,
373: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
374: ben_prtn_elig_prfl_f cep
375: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
376: cep.eligy_prfl_id = eap.eligy_prfl_id) and
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,