APPS.BEN_ICD_PLAN_DESIGN_SETUP dependencies on BEN_PRTN_ELIG_PRFL_F

Line 268: from ben_prtn_elig_prfl_f prfl

264: select prfl.prtn_elig_prfl_id
265: ,prfl.effective_start_date
266: ,prfl.effective_end_date
267: ,prfl.object_version_number
268: from ben_prtn_elig_prfl_f prfl
269: where prfl.prtn_elig_id = p_prtn_elig_id
270: and p_effective_date between
271: prfl.effective_start_date and prfl.effective_end_date;
272: l_esd date;