Product: | PER - Human Resources |
---|---|
Description: | Secure view based on the corresponding _ALL_ table. |
Implementation/DBA Data: | APPS.PER_VACANCIES |
SELECT VACANCY_ID
, BUSINESS_GROUP_ID
, POSITION_ID
, JOB_ID
, GRADE_ID
, ORGANIZATION_ID
, REQUISITION_ID
, PEOPLE_GROUP_ID
, LOCATION_ID
, RECRUITER_ID
, DATE_FROM
, NAME
, COMMENTS
, DATE_TO
, DESCRIPTION
, VACANCY_CATEGORY
, NUMBER_OF_OPENINGS
, STATUS
, BUDGET_MEASUREMENT_TYPE
, BUDGET_MEASUREMENT_VALUE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, MANAGER_ID
, SECURITY_METHOD
, OBJECT_VERSION_NUMBER
FROM PER_ALL_VACANCIES PAV
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_VACANCIES'
, PAV.VACANCY_ID
, PAV.ORGANIZATION_ID
, PAV.POSITION_ID
, PAV.MANAGER_ID
, PAV.SECURITY_METHOD)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAV.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAV.BUSINESS_GROUP_ID