View: PER_POSITIONS

Product:	PER - Human Resources
Description:	Secure view based on the corresponding _ALL_ table.
Implementation/DBA Data:	APPS.PER_POSITIONS

View Text

SELECT PAP.POSITION_ID
, PAP.BUSINESS_GROUP_ID
, PAP.JOB_ID
, PAP.ORGANIZATION_ID
, PAP.SUCCESSOR_POSITION_ID
, PAP.RELIEF_POSITION_ID
, PAP.LOCATION_ID
, PAP.POSITION_DEFINITION_ID
, PAP.DATE_EFFECTIVE
, PAP.COMMENTS
, PAP.DATE_END
, PAP.FREQUENCY
, PFT. NAME
, PAP.PROBATION_PERIOD
, PAP.PROBATION_PERIOD_UNITS
, PAP.REPLACEMENT_REQUIRED_FLAG
, PAP.TIME_NORMAL_FINISH
, PAP.TIME_NORMAL_START
, PAP.WORKING_HOURS
, PAP.STATUS
, PAP.REQUEST_ID
, PAP.PROGRAM_APPLICATION_ID
, PAP.PROGRAM_ID
, PAP.PROGRAM_UPDATE_DATE
, PAP.ATTRIBUTE_CATEGORY
, PAP.ATTRIBUTE1
, PAP.ATTRIBUTE2
, PAP.ATTRIBUTE3
, PAP.ATTRIBUTE4
, PAP.ATTRIBUTE5
, PAP.ATTRIBUTE6
, PAP.ATTRIBUTE7
, PAP.ATTRIBUTE8
, PAP.ATTRIBUTE9
, PAP.ATTRIBUTE10
, PAP.ATTRIBUTE11
, PAP.ATTRIBUTE12
, PAP.ATTRIBUTE13
, PAP.ATTRIBUTE14
, PAP.ATTRIBUTE15
, PAP.ATTRIBUTE16
, PAP.ATTRIBUTE17
, PAP.ATTRIBUTE18
, PAP.ATTRIBUTE19
, PAP.ATTRIBUTE20
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.LAST_UPDATE_LOGIN
, PAP.CREATED_BY
, PAP.CREATION_DATE
, PAP.OBJECT_VERSION_NUMBER
FROM PER_ALL_POSITIONS PAP
, HR_ALL_POSITIONS_F_TL PFT
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS'
, PAP.POSITION_ID)) ='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAP.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAP.BUSINESS_GROUP_ID
AND PAP.POSITION_ID = PFT.POSITION_ID
AND PFT.LANGUAGE = USERENV('LANG')

Columns