DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_HLTH_CVG_PRTE_F

Line 13277: from ben_elig_hlth_cvg_prte_f tab

13273: select tab.eligy_prfl_id,
13274: tab.pl_typ_opt_typ_id,
13275: tab.oipl_id,
13276: tab.excld_flag
13277: from ben_elig_hlth_cvg_prte_f tab
13278: where tab.eligy_prfl_id = c_eligy_prfl_id
13279: and c_effective_date
13280: between tab.effective_start_date and tab.effective_end_date
13281: order by tab.eligy_prfl_id,