VIEW: APPS.PAY_WCI_OCCUPATIONS_V

Source

View Text - Preformatted

SELECT pwo.occupation_id ,pwo.business_group_id ,pwo.rate_id ,pwo.job_id ,pjt.name ,pj.date_from ,pj.date_to ,pwo.last_updated_by ,pwo.last_update_login ,pwo.last_update_date ,pwo.created_by ,pwo.creation_date ,pwo.object_version_number from pay_wci_occupations pwo, per_jobs_tl pjt, per_jobs pj WHERE pwo.job_id = pj.job_id and pjt.job_id = pj.job_id and pjt.language = userenv('LANG')

View Text - HTML Formatted

SELECT PWO.OCCUPATION_ID
, PWO.BUSINESS_GROUP_ID
, PWO.RATE_ID
, PWO.JOB_ID
, PJT.NAME
, PJ.DATE_FROM
, PJ.DATE_TO
, PWO.LAST_UPDATED_BY
, PWO.LAST_UPDATE_LOGIN
, PWO.LAST_UPDATE_DATE
, PWO.CREATED_BY
, PWO.CREATION_DATE
, PWO.OBJECT_VERSION_NUMBER
FROM PAY_WCI_OCCUPATIONS PWO
, PER_JOBS_TL PJT
, PER_JOBS PJ
WHERE PWO.JOB_ID = PJ.JOB_ID
AND PJT.JOB_ID = PJ.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')