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
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),