111: tab3.elig_perf_rtng_flag,
112: tab3.elig_crit_values_flag
113: from ben_prtn_elig_f tab1,
114: ben_prtn_elig_prfl_f tab2,
115: ben_eligy_prfl_f tab3
116: where tab1.pgm_id = c_pgm_id
117: and tab1.prtn_elig_id = tab2.prtn_elig_id
118: and c_effective_date
119: between tab1.effective_start_date
221: tab3.elig_perf_rtng_flag,
222: tab3.elig_crit_values_flag
223: from ben_prtn_elig_f tab1,
224: ben_prtn_elig_prfl_f tab2,
225: ben_eligy_prfl_f tab3
226: where tab1.ptip_id = c_ptip_id
227: and tab1.prtn_elig_id = tab2.prtn_elig_id
228: and c_effective_date
229: between tab1.effective_start_date
329: tab3.elig_perf_rtng_flag,
330: tab3.elig_crit_values_flag
331: from ben_prtn_elig_f tab1,
332: ben_prtn_elig_prfl_f tab2,
333: ben_eligy_prfl_f tab3
334: where tab1.plip_id = c_plip_id
335: and tab1.prtn_elig_id = tab2.prtn_elig_id
336: and c_effective_date
337: between tab1.effective_start_date
437: tab3.elig_perf_rtng_flag,
438: tab3.elig_crit_values_flag
439: from ben_prtn_elig_f tab1,
440: ben_prtn_elig_prfl_f tab2,
441: ben_eligy_prfl_f tab3
442: where tab1.pl_id = c_pl_id
443: and tab1.prtn_elig_id = tab2.prtn_elig_id
444: and c_effective_date
445: between tab1.effective_start_date
545: tab3.elig_perf_rtng_flag,
546: tab3.elig_crit_values_flag
547: from ben_prtn_elig_f tab1,
548: ben_prtn_elig_prfl_f tab2,
549: ben_eligy_prfl_f tab3
550: where tab1.oipl_id = c_oipl_id
551: and tab1.prtn_elig_id = tab2.prtn_elig_id
552: and c_effective_date
553: between tab1.effective_start_date
652: tab3.elig_perf_rtng_flag,
653: tab3.elig_crit_values_flag
654: from ben_vrbl_rt_prfl_f tab1,
655: ben_vrbl_rt_elig_prfl_f tab2,
656: ben_eligy_prfl_f tab3
657: where tab1.vrbl_rt_prfl_id = c_vrbl_rt_prfl_id
658: and tab1.vrbl_rt_prfl_id = tab2.vrbl_rt_prfl_id
659: and c_effective_date
660: between tab1.effective_start_date