DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_PPL_GRP_PRTE_F

Line 2042: from ben_elig_ppl_grp_prte_f epg

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)

Line 2087: from ben_elig_ppl_grp_prte_f epg

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