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')
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')
|
|
|