APPS.GHR_SF52_VALIDN_PKG dependencies on HR_ALL_POSITIONS_F

Line 241: from hr_all_positions_f pos

237: l_proc varchar2(72) := g_package ||'chk_position_title_seq_desc' ;
238:
239: cursor c_bgp_id is
240: select pos.business_group_id
241: from hr_all_positions_f pos
242: where pos.position_id = p_to_position_id
243: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
244:
245: