DBA Data[Home] [Help]

APPS.HRWSECI dependencies on HR_POSITIONS

Line 238: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date tracked positions requirement

234: WHERE ou.organization_id = p_organization_id
235: AND ou.business_group_id + 0 = p_business_group_id
236: AND ou.date_from <=p_qualifying_date;
237: --
238: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date tracked positions requirement
239: --
240: CURSOR get_pos_std_hrs IS
241: SELECT working_hours
242: FROM hr_positions

Line 242: FROM hr_positions

238: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date tracked positions requirement
239: --
240: CURSOR get_pos_std_hrs IS
241: SELECT working_hours
242: FROM hr_positions
243: WHERE position_id = p_position_id;
244: --
245: CURSOR chk_hrs_reduced IS
246: SELECT 'Y'