2038: where p_effective_date
2039: between elp.effective_start_date
2040: and elp.effective_end_date
2041: and exists(select null
2042: from ben_elig_ppl_grp_prte_f epg
2043: where p_effective_date
2044: between epg.effective_start_date
2045: and epg.effective_end_date
2046: and epg.eligy_prfl_id = elp.eligy_prfl_id)
2083: ppg.segment27,
2084: ppg.segment28,
2085: ppg.segment29,
2086: ppg.segment30
2087: from ben_elig_ppl_grp_prte_f epg
2088: ,pay_people_groups ppg
2089: where p_effective_date
2090: between epg.effective_start_date
2091: and epg.effective_end_date