VIEW: APPS.PER_POSITIONS

Source

View Text - Preformatted

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.ATTRIBUTE21 ,PAP.ATTRIBUTE22 ,PAP.ATTRIBUTE23 ,PAP.ATTRIBUTE24 ,PAP.ATTRIBUTE25 ,PAP.ATTRIBUTE26 ,PAP.ATTRIBUTE27 ,PAP.ATTRIBUTE28 ,PAP.ATTRIBUTE29 ,PAP.ATTRIBUTE30 ,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')

View Text - HTML Formatted

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.ATTRIBUTE21
, PAP.ATTRIBUTE22
, PAP.ATTRIBUTE23
, PAP.ATTRIBUTE24
, PAP.ATTRIBUTE25
, PAP.ATTRIBUTE26
, PAP.ATTRIBUTE27
, PAP.ATTRIBUTE28
, PAP.ATTRIBUTE29
, PAP.ATTRIBUTE30
, 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')