DBA Data[Home] [Help]

APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_JOBS_TL

Line 263: ,per_jobs_tl jbt

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
267: and ass.effective_end_date