270: WHERE ou.organization_id = p_organization_id
271: AND ou.business_group_id + 0 = p_business_group_id
272: AND ou.date_from <=p_qualifying_date;
273: --
274: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions requirement
275: --
276: CURSOR get_pos_std_hrs IS
277: SELECT working_hours
278: FROM hr_positions_f
274: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions requirement
275: --
276: CURSOR get_pos_std_hrs IS
277: SELECT working_hours
278: FROM hr_positions_f
279: WHERE position_id = p_position_id
280: and p_qualifying_date
281: between effective_start_date
282: and effective_end_date;