VIEW: APPS.PA_XLA_PER_JOBS_REF_V

Source

View Text - Preformatted

SELECT job.job_id, job.name, job.job_group_id, job_group.displayed_name from per_jobs job, per_job_groups job_group WHERE job.job_group_id = job_group.job_group_id

View Text - HTML Formatted

SELECT JOB.JOB_ID
, JOB.NAME
, JOB.JOB_GROUP_ID
, JOB_GROUP.DISPLAYED_NAME
FROM PER_JOBS JOB
, PER_JOB_GROUPS JOB_GROUP
WHERE JOB.JOB_GROUP_ID = JOB_GROUP.JOB_GROUP_ID