DBA Data[Home] [Help]

APPS.PER_CTK_INS dependencies on BEN_ELIGY_PRFL_F

Line 287: ben_eligy_prfl_f

283: cursor c_elig_prfl_dates(cur_p_elig_prfl_id number) is
284: select
285: effective_start_date
286: FROM
287: ben_eligy_prfl_f
288: WHERE
289: trunc(sysdate) between effective_start_date and effective_end_date
290: AND stat_cd = 'A'
291: AND bnft_cagr_prtn_cd = 'CHKLIST'