DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_OTHR_PTIP_PRTE_F

Line 9618: from ben_elig_othr_ptip_prte_f eoy

9614: where p_effective_date
9615: between elp.effective_start_date
9616: and elp.effective_end_date
9617: and exists(select null
9618: from ben_elig_othr_ptip_prte_f eoy
9619: where p_effective_date
9620: between eoy.effective_start_date
9621: and eoy.effective_end_date
9622: and eoy.eligy_prfl_id = elp.eligy_prfl_id)

Line 9630: from ben_elig_othr_ptip_prte_f eoy

9626: select eoy.eligy_prfl_id,
9627: eoy.ptip_id,
9628: eoy.only_pls_subj_cobra_flag,
9629: eoy.excld_flag
9630: from ben_elig_othr_ptip_prte_f eoy
9631: where p_effective_date
9632: between eoy.effective_start_date
9633: and eoy.effective_end_date
9634: order by eoy.eligy_prfl_id,