DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_ELIGY_PRFL_F

Line 7098: l_eligy_prfl_name ben_eligy_prfl_f.name%type := null;

7094: p_eligy_prfl_id in number
7095: ,p_effective_date in date
7096: ) return varchar2 is
7097:
7098: l_eligy_prfl_name ben_eligy_prfl_f.name%type := null;
7099:
7100: cursor c_eligy_prfl_name is
7101: select elp.name
7102: from ben_eligy_prfl_f elp

Line 7102: from ben_eligy_prfl_f elp

7098: l_eligy_prfl_name ben_eligy_prfl_f.name%type := null;
7099:
7100: cursor c_eligy_prfl_name is
7101: select elp.name
7102: from ben_eligy_prfl_f elp
7103: where elp.eligy_prfl_id = p_eligy_prfl_id
7104: and p_effective_date between elp.effective_start_date
7105: and elp.effective_end_date;
7106: