APPS.GHR_BREAKDOWN_RPT dependencies on PER_JOBS

Line 325: per_jobs job

321: THEN
322: SELECT job.name || ' - ' || decode_lookup('GHR_US_OCC_SERIES', job.name)
323: INTO l_result
324: FROM hr_all_positions_f POS,
325: per_jobs job
326: WHERE POS.position_id = p_ASG.position_id
327: AND TRUNC(effective_date) BETWEEN POS.effective_start_date
328: AND POS.effective_end_date
329: AND JOB.job_id = POS.job_id;