APPS.PQH_RBC_LOAD_OBJECTS dependencies on BEN_ELIGY_PRFL_F

Line 182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;

178: ,p_owner in varchar2
179: ) is
180: --
181: l_pl_id ben_pl_f.pl_id%type ;
182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;
183: l_business_group_id hr_all_organization_units.business_group_id%type;
184: --
185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
186: l_parent_node_id pqh_rate_matrix_nodes.parent_node_id%type;

Line 221: select eligy_prfl_id from ben_eligy_prfl_f

217: --
218: -- Find eligibility profile
219: --
220: Cursor csr_elg is
221: select eligy_prfl_id from ben_eligy_prfl_f
222: where name = p_eligy_prfl_name
223: and l_effective_date between effective_start_date and effective_end_date
224: and business_group_id = l_business_group_id;
225: --