DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_HLTH_CVG_PRTE_F

Line 13671: from ben_elig_hlth_cvg_prte_f tab

13667: select tab.eligy_prfl_id,
13668: tab.pl_typ_opt_typ_id,
13669: tab.oipl_id,
13670: tab.excld_flag
13671: from ben_elig_hlth_cvg_prte_f tab
13672: where tab.eligy_prfl_id = c_eligy_prfl_id
13673: and c_effective_date
13674: between tab.effective_start_date and tab.effective_end_date
13675: order by tab.eligy_prfl_id,