APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_VRBL_RT_PRFL_F

Line 6635: l_vrbl_rt_prfl_name ben_vrbl_rt_prfl_f.name%type := null;

6631: p_vrbl_rt_prfl_id in number
6632: ,p_effective_date in date
6633: ) return varchar2 is
6634:
6635: l_vrbl_rt_prfl_name ben_vrbl_rt_prfl_f.name%type := null;
6636:
6637: cursor c_vrbl_rt_prfl_name is
6638: select vpf.name
6639: from ben_vrbl_rt_prfl_f vpf

Line 6639: from ben_vrbl_rt_prfl_f vpf

6635: l_vrbl_rt_prfl_name ben_vrbl_rt_prfl_f.name%type := null;
6636:
6637: cursor c_vrbl_rt_prfl_name is
6638: select vpf.name
6639: from ben_vrbl_rt_prfl_f vpf
6640: where vpf.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
6641: and p_effective_date between vpf.effective_start_date
6642: and vpf.effective_end_date;
6643: