APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_JOBS_VL

Line 262: ,per_jobs_vl job

258: cursor c_job_cat is
259: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
260: from hr_lookups lup
261: ,per_all_assignments_f ass
262: ,per_jobs_vl job
263: ,per_jobs_tl jbt
264: where ass.person_id = person_id1
265:
266: and report_date_end between ass.effective_start_date