VIEW: APPS.HRBV_ALL_VACANCIES_V

Source

View Text - Preformatted

SELECT VAC.DATE_FROM, VAC.NAME, VAC.COMMENTS, VAC.DATE_TO, VAC.DESCRIPTION, VAC.NUMBER_OF_OPENINGS, VAC.STATUS, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_STATUS',VAC.STATUS), VAC.BUDGET_MEASUREMENT_TYPE, HR_BIS.BIS_DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE',VAC.BUDGET_MEASUREMENT_TYPE), VAC.BUDGET_MEASUREMENT_VALUE, VAC.VACANCY_CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_CATEGORY',VAC.VACANCY_CATEGORY), VAC.SECURITY_METHOD, HR_BIS.BIS_DECODE_LOOKUP('IRC_SECURITY_METHOD',VAC.SECURITY_METHOD), '_DF:PER:PER_VACANCIES:VAC', VAC.VACANCY_ID, VAC.BUSINESS_GROUP_ID, VAC.POSITION_ID, VAC.JOB_ID, VAC.GRADE_ID, VAC.ORGANIZATION_ID, VAC.REQUISITION_ID, VAC.PEOPLE_GROUP_ID, VAC.LOCATION_ID, VAC.RECRUITER_ID, VAC.MANAGER_ID, VAC.LAST_UPDATE_DATE, VAC.LAST_UPDATED_BY, VAC.CREATED_BY, VAC.CREATION_DATE, CASE WHEN VAC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, VAC.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_VACANCIES VAC WITH READ ONLY

View Text - HTML Formatted

SELECT VAC.DATE_FROM
, VAC.NAME
, VAC.COMMENTS
, VAC.DATE_TO
, VAC.DESCRIPTION
, VAC.NUMBER_OF_OPENINGS
, VAC.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_STATUS'
, VAC.STATUS)
, VAC.BUDGET_MEASUREMENT_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, VAC.BUDGET_MEASUREMENT_TYPE)
, VAC.BUDGET_MEASUREMENT_VALUE
, VAC.VACANCY_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_CATEGORY'
, VAC.VACANCY_CATEGORY)
, VAC.SECURITY_METHOD
, HR_BIS.BIS_DECODE_LOOKUP('IRC_SECURITY_METHOD'
, VAC.SECURITY_METHOD)
, '_DF:PER:PER_VACANCIES:VAC'
, VAC.VACANCY_ID
, VAC.BUSINESS_GROUP_ID
, VAC.POSITION_ID
, VAC.JOB_ID
, VAC.GRADE_ID
, VAC.ORGANIZATION_ID
, VAC.REQUISITION_ID
, VAC.PEOPLE_GROUP_ID
, VAC.LOCATION_ID
, VAC.RECRUITER_ID
, VAC.MANAGER_ID
, VAC.LAST_UPDATE_DATE
, VAC.LAST_UPDATED_BY
, VAC.CREATED_BY
, VAC.CREATION_DATE
, CASE WHEN VAC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, VAC.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_VACANCIES VAC WITH READ ONLY