APPS.PER_ASG_BUS1 dependencies on HR_ALL_POSITIONS_F

Line 7303: from hr_all_positions_f

7299: l_asg_in_overlap_dates boolean;
7300: --
7301: cursor c_position_type(p_position_id number, p_effective_date date) is
7302: select position_type, availability_status_id, business_group_id
7303: from hr_all_positions_f
7304: where position_id = p_position_id
7305: and p_effective_date between effective_start_date and effective_end_date;
7306: --
7307: begin