VIEW: APPS.PER_VACANCIES

Source

View Text - Preformatted

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 , PRIMARY_POSTING_ID , ASSESSMENT_ID , 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, PAV.BUSINESS_GROUP_ID)) = 'TRUE' AND decode(hr_general.get_xbg_profile,'Y', pav.business_group_id , hr_general.get_business_group_id) = pav.business_group_id

View Text - HTML Formatted

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
, PRIMARY_POSTING_ID
, ASSESSMENT_ID
, 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
, PAV.BUSINESS_GROUP_ID)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAV.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAV.BUSINESS_GROUP_ID