2315: ,p_record_indicator IN VARCHAR2) IS
2316: CURSOR c_job IS
2317: SELECT job.name
2318: FROM hr_all_positions_f pos,
2319: per_jobs job
2320: WHERE pos.position_id = p_position_id
2321: AND p_date_effective BETWEEN pos.effective_start_date
2322: AND pos.effective_end_date
2323: AND job.job_id = pos.job_id;