DBA Data[Home] [Help]

APPS.PER_SUC_BUS dependencies on HR_POSITIONS_F

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