DBA Data[Home] [Help]

APPS.PER_CEL_BUS dependencies on HR_POSITIONS_F

Line 1183: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) date track position req.

1179: -- where p_person_id = person_id;
1180: --
1181: -- Cursor to check that the position_id exists
1182: --
1183: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) date track position req.
1184: --
1185: cursor csr_valid_position_id is
1186: select business_group_id, date_effective, hr_general.get_position_date_end(p_position_id)
1187: from hr_positions_f

Line 1187: from hr_positions_f

1183: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions_f) date track position req.
1184: --
1185: cursor csr_valid_position_id is
1186: select business_group_id, date_effective, hr_general.get_position_date_end(p_position_id)
1187: from hr_positions_f
1188: where p_position_id = position_id;
1189: -- and p_effective_date
1190: -- between effective_start_date
1191: -- and effective_end_date;