DBA Data[Home] [Help]

APPS.PER_COBRA_ECI dependencies on HR_POSITIONS_F

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

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

Line 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;