DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on HR_POSITIONS_F

Line 58: 12-Jun-00 hsajja 115.5 Changed HR_POSITIONS to HR_POSITIONS_F

54: Table Handler procedures
55: 21-MAY-99 C.Carter 115.3 Removed set_token call after error
56: message 6125.
57: 05-Oct-99 SCNair 115.4 Date Track position related changes
58: 12-Jun-00 hsajja 115.5 Changed HR_POSITIONS to HR_POSITIONS_F
59: and corresponding effective_date changes
60: 26-Jun-00 C.Carter 115.6 Changed PER_JOBS to PER_JOBS_V.
61: 07-SEP-01 A.Cowan 115.7-10 Cascade vacancy enhancement
62: bug # 1923803

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

586: PROCEDURE D_from_updt_pos_chk(P_Business_group_id NUMBER,
587: P_vac_date_from DATE,
588: P_position_id NUMBER) IS
589: --
590: -- Changed 05-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions requirement
591: CURSOR c_pos_chk IS
592: SELECT 1
593: FROM HR_POSITIONS_F POS
594: WHERE POS.POSITION_ID = P_position_id

Line 593: FROM HR_POSITIONS_F POS

589: --
590: -- Changed 05-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions requirement
591: CURSOR c_pos_chk IS
592: SELECT 1
593: FROM HR_POSITIONS_F POS
594: WHERE POS.POSITION_ID = P_position_id
595: AND POS.business_group_id + 0 = P_Business_group_id
596: AND P_vac_date_from < POS.DATE_EFFECTIVE;
597: