APPS.PER_SUC_BUS dependencies on HR_POSITIONS

Line 251: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions req.

247: l_api_updating BOOLEAN;
248: l_dummy VARCHAR2 (1);
249:
250: --
251: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions req.
252: --
253: CURSOR c1
254: IS
255: SELECT NULL

Line 256: FROM hr_positions_f per

252: --
253: CURSOR c1
254: IS
255: SELECT NULL
256: FROM hr_positions_f per
257: WHERE per.position_id = NVL (p_position_id, -1)
258: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
259: AND p_effective_date BETWEEN per.date_effective
260: AND NVL (hr_general.get_position_date_end (per.position_id),

Line 1244: l_curr_position_id hr_positions.position_id%TYPE;

1240: p_person_id per_people_f.person_id%TYPE,
1241: p_start_date per_assignments_f.effective_start_date%TYPE
1242: )
1243: IS
1244: l_curr_position_id hr_positions.position_id%TYPE;
1245:
1246: CURSOR person_start_details (
1247: p_person_id per_people_f.person_id%TYPE,
1248: p_start_date per_assignments_f.effective_start_date%TYPE