APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_JOBS_VL

Line 274: ,per_jobs_vl job

270: cursor c_job_cat is
271: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
272: from hr_lookups lup
273: ,per_all_assignments_f ass
274: ,per_jobs_vl job
275: ,per_jobs_tl jbt
276: where ass.person_id = person_id1
277:
278: and report_date_end between ass.effective_start_date