[Home] [Help] [Dependency Information]

VIEW: APPS.PER_VACANCIES

Object Details

Object Name:	PER_VACANCIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_VACANCIES
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PER_VACANCIES is a view based on the table PER_ALL_VACANCIES. It lists
all of the vacancies visible within the current security profile.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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 APPS.PER_VACANCIES;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ALL_VACANCIES

APPS

HRBV_ALL_VACANCIES_V

HRFV_REC_ACT_BY_VACANCIES

HRFV_VACANCIES

HRI_CL_RQNVAC_VACNCY_H_V

HRI_CL_RQNVAC_VACNCY_V

HR_APPLICANT_API - show dependent code

HR_APPLICANT_INTERNAL - show dependent code

HR_APPROVAL_WF - show dependent code

HR_CONTINGENT_WORKER_API - show dependent code

HR_DELETE - show dependent code

HR_EMPLOYEE_API - show dependent code

HR_EX_EMPLOYEE_API - show dependent code

HR_HEAD_COUNT - show dependent code

HR_MASS_MOVE_API - show dependent code

HR_ORG_PRE_DELETE - show dependent code

HR_PERSON_DELETE - show dependent code

HR_PERSON_INTERNAL - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PSF_DEL - show dependent code

HR_SUIT_MATCH_UTILITY_WEB - show dependent code

IRCFV_JOB_MATCHING_PREFERENCES

IRCFV_REC_TEAM_MEMBERS

IRCFV_VACANCIES

IRCFV_VACANCY_CONSIDERATION

IRC_PARTY_API - show dependent code

IRC_SEEKER_VAC_MATCHING_PKG - show dependent code

IRC_UTILITIES_PKG - show dependent code

PER_APPLICANT_PKG - show dependent code

PER_APP_ASGS_V

PER_ASG_BUS2 - show dependent code

PER_CANCEL_HIRE_OR_APL_PKG - show dependent code

PER_DB_PER_ADDITIONAL - show dependent code

PER_GENERIC_REPORT_PKG - show dependent code

PER_GRADES_PKG - show dependent code

PER_GRD_BUS - show dependent code

PER_IREC_ICD_ENRLL_PROCESS - show dependent code

PER_JOBS_PKG - show dependent code

PER_JOB_BUS - show dependent code

PER_LETTER_REQUESTS_V

PER_POSITIONS_PKG - show dependent code

PER_QH_ACTION - show dependent code

PER_QH_ACTION - show dependent code

PER_QH_FIND_QUERY - show dependent code

PER_QH_FIND_QUERY - show dependent code

PER_QH_MAINTAIN_QUERY - show dependent code

PER_QH_MAINTAIN_QUERY - show dependent code

PER_QH_POPULATE - show dependent code

PER_QH_POPULATE - show dependent code

PER_QH_SUMMARY_QUERY - show dependent code

PER_RECRUITMENT_ACTIVITIES_PKG - show dependent code

PER_REQUISITIONS_PKG - show dependent code

PER_VACANCIES_PKG - show dependent code

PER_VACANCIES_PKG - show dependent code

PER_VACANCIES_V

PER_VACANCIES_V2