VIEW: APPS.HR_POSITIONS_F

Source

View Text - Preformatted

SELECT POSITION_ID ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,AVAILABILITY_STATUS_ID ,BUSINESS_GROUP_ID ,ENTRY_GRADE_ID ,ENTRY_GRADE_RULE_ID ,ENTRY_STEP_ID ,JOB_ID ,LOCATION_ID ,ORGANIZATION_ID ,PAY_FREQ_PAYROLL_ID ,position_definition_id ,date_effective_pos_def_id ,POSITION_TRANSACTION_ID ,PRIOR_POSITION_ID ,RELIEF_POSITION_ID ,SUCCESSOR_POSITION_ID ,SUPERVISOR_POSITION_ID ,AMENDMENT_DATE ,AMENDMENT_RECOMMENDATION ,AMENDMENT_REF_NUMBER ,BARGAINING_UNIT_CD ,COMMENTS ,CURRENT_JOB_PROP_END_DATE ,CURRENT_ORG_PROP_END_DATE ,AVAIL_STATUS_PROP_END_DATE ,DATE_EFFECTIVE ,DATE_END ,EARLIEST_HIRE_DATE ,FILL_BY_DATE ,FREQUENCY ,FTE ,MAX_PERSONS ,NAME ,date_effective_name ,OVERLAP_PERIOD ,OVERLAP_UNIT_CD ,PAY_TERM_END_DAY_CD ,PAY_TERM_END_MONTH_CD ,PERMANENT_TEMPORARY_FLAG ,PERMIT_RECRUITMENT_FLAG ,POSITION_TYPE ,POSTING_DESCRIPTION ,PROBATION_PERIOD ,PROBATION_PERIOD_UNIT_CD ,PROPOSED_FTE_FOR_LAYOFF ,PROPOSED_DATE_FOR_LAYOFF ,REPLACEMENT_REQUIRED_FLAG ,REVIEW_FLAG ,SEASONAL_FLAG ,SECURITY_REQUIREMENTS ,STATUS ,TERM_START_DAY_CD ,TERM_START_MONTH_CD ,TIME_NORMAL_FINISH ,TIME_NORMAL_START ,UPDATE_SOURCE_CD ,WORKING_HOURS ,WORKS_COUNCIL_APPROVAL_FLAG ,WORK_PERIOD_TYPE_CD ,WORK_TERM_END_DAY_CD ,WORK_TERM_END_MONTH_CD ,PAY_BASIS_ID ,SUPERVISOR_ID ,INFORMATION1 ,INFORMATION2 ,INFORMATION3 ,INFORMATION4 ,INFORMATION5 ,INFORMATION6 ,INFORMATION7 ,INFORMATION8 ,INFORMATION9 ,INFORMATION10 ,INFORMATION11 ,INFORMATION12 ,INFORMATION13 ,INFORMATION14 ,INFORMATION15 ,INFORMATION16 ,INFORMATION17 ,INFORMATION18 ,INFORMATION19 ,INFORMATION20 ,INFORMATION21 ,INFORMATION22 ,INFORMATION23 ,INFORMATION24 ,INFORMATION25 ,INFORMATION26 ,INFORMATION27 ,INFORMATION28 ,INFORMATION29 ,INFORMATION30 ,INFORMATION_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,ATTRIBUTE21 ,ATTRIBUTE22 ,ATTRIBUTE23 ,ATTRIBUTE24 ,ATTRIBUTE25 ,ATTRIBUTE26 ,ATTRIBUTE27 ,ATTRIBUTE28 ,ATTRIBUTE29 ,ATTRIBUTE30 ,ATTRIBUTE_CATEGORY ,REQUEST_ID ,PROGRAM_APPLICATION_ID ,PROGRAM_ID ,PROGRAM_UPDATE_DATE ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,OBJECT_VERSION_NUMBER from ( SELECT hapf.POSITION_ID ,hapf.EFFECTIVE_START_DATE ,hapf.EFFECTIVE_END_DATE ,hapf.AVAILABILITY_STATUS_ID ,hapf.BUSINESS_GROUP_ID ,hapf.ENTRY_GRADE_ID ,hapf.ENTRY_GRADE_RULE_ID ,hapf.ENTRY_STEP_ID ,hapf.JOB_ID ,hapf.LOCATION_ID ,hapf.ORGANIZATION_ID ,hapf.PAY_FREQ_PAYROLL_ID ,hpf1.position_definition_id date_effective_pos_def_id ,hapf.position_definition_id ,hapf.POSITION_TRANSACTION_ID ,hapf.PRIOR_POSITION_ID ,hapf.RELIEF_POSITION_ID ,hapf.SUCCESSOR_POSITION_ID ,hapf.SUPERVISOR_POSITION_ID ,hapf.AMENDMENT_DATE ,hapf.AMENDMENT_RECOMMENDATION ,hapf.AMENDMENT_REF_NUMBER ,hapf.BARGAINING_UNIT_CD ,hapf.COMMENTS ,hapf.CURRENT_JOB_PROP_END_DATE ,hapf.CURRENT_ORG_PROP_END_DATE ,hapf.AVAIL_STATUS_PROP_END_DATE ,hapf.DATE_EFFECTIVE ,hr_general.get_POSITION_DATE_END(hapf.position_id) date_end ,hapf.EARLIEST_HIRE_DATE ,hapf.FILL_BY_DATE ,hapf.FREQUENCY ,hapf.FTE ,hapf.MAX_PERSONS ,pft.name /*,hr_general.decode_position_latest_NAME(hapf.position_id)*/ ,hapf.name date_effective_name ,hapf.OVERLAP_PERIOD ,hapf.OVERLAP_UNIT_CD ,hapf.PAY_TERM_END_DAY_CD ,hapf.PAY_TERM_END_MONTH_CD ,hapf.PERMANENT_TEMPORARY_FLAG ,hapf.PERMIT_RECRUITMENT_FLAG ,hapf.POSITION_TYPE ,hapf.POSTING_DESCRIPTION ,hapf.PROBATION_PERIOD ,hapf.PROBATION_PERIOD_UNIT_CD ,hapf.PROPOSED_FTE_FOR_LAYOFF ,hapf.PROPOSED_DATE_FOR_LAYOFF ,hapf.REPLACEMENT_REQUIRED_FLAG ,hapf.REVIEW_FLAG ,hapf.SEASONAL_FLAG ,hapf.SECURITY_REQUIREMENTS ,hapf.STATUS ,hapf.TERM_START_DAY_CD ,hapf.TERM_START_MONTH_CD ,hapf.TIME_NORMAL_FINISH ,hapf.TIME_NORMAL_START ,hapf.UPDATE_SOURCE_CD ,hapf.WORKING_HOURS ,hapf.WORKS_COUNCIL_APPROVAL_FLAG ,hapf.WORK_PERIOD_TYPE_CD ,hapf.WORK_TERM_END_DAY_CD ,hapf.WORK_TERM_END_MONTH_CD ,hapf.PAY_BASIS_ID ,hapf.SUPERVISOR_ID ,hapf.INFORMATION1 ,hapf.INFORMATION2 ,hapf.INFORMATION3 ,hapf.INFORMATION4 ,hapf.INFORMATION5 ,hapf.INFORMATION6 ,hapf.INFORMATION7 ,hapf.INFORMATION8 ,hapf.INFORMATION9 ,hapf.INFORMATION10 ,hapf.INFORMATION11 ,hapf.INFORMATION12 ,hapf.INFORMATION13 ,hapf.INFORMATION14 ,hapf.INFORMATION15 ,hapf.INFORMATION16 ,hapf.INFORMATION17 ,hapf.INFORMATION18 ,hapf.INFORMATION19 ,hapf.INFORMATION20 ,hapf.INFORMATION21 ,hapf.INFORMATION22 ,hapf.INFORMATION23 ,hapf.INFORMATION24 ,hapf.INFORMATION25 ,hapf.INFORMATION26 ,hapf.INFORMATION27 ,hapf.INFORMATION28 ,hapf.INFORMATION29 ,hapf.INFORMATION30 ,hapf.INFORMATION_CATEGORY ,hapf.ATTRIBUTE1 ,hapf.ATTRIBUTE2 ,hapf.ATTRIBUTE3 ,hapf.ATTRIBUTE4 ,hapf.ATTRIBUTE5 ,hapf.ATTRIBUTE6 ,hapf.ATTRIBUTE7 ,hapf.ATTRIBUTE8 ,hapf.ATTRIBUTE9 ,hapf.ATTRIBUTE10 ,hapf.ATTRIBUTE11 ,hapf.ATTRIBUTE12 ,hapf.ATTRIBUTE13 ,hapf.ATTRIBUTE14 ,hapf.ATTRIBUTE15 ,hapf.ATTRIBUTE16 ,hapf.ATTRIBUTE17 ,hapf.ATTRIBUTE18 ,hapf.ATTRIBUTE19 ,hapf.ATTRIBUTE20 ,hapf.ATTRIBUTE21 ,hapf.ATTRIBUTE22 ,hapf.ATTRIBUTE23 ,hapf.ATTRIBUTE24 ,hapf.ATTRIBUTE25 ,hapf.ATTRIBUTE26 ,hapf.ATTRIBUTE27 ,hapf.ATTRIBUTE28 ,hapf.ATTRIBUTE29 ,hapf.ATTRIBUTE30 ,hapf.ATTRIBUTE_CATEGORY ,hapf.REQUEST_ID ,hapf.PROGRAM_APPLICATION_ID ,hapf.PROGRAM_ID ,hapf.PROGRAM_UPDATE_DATE ,hapf.CREATED_BY ,hapf.CREATION_DATE ,hapf.LAST_UPDATED_BY ,hapf.LAST_UPDATE_DATE ,hapf.LAST_UPDATE_LOGIN ,hapf.OBJECT_VERSION_NUMBER from hr_all_positions_f hapf ,hr_all_positions_f hpf1 , hr_all_positions_f_tl pft WHERE pft.position_id = hapf.position_id and pft.language = userenv('LANG') and nvl(fnd_profile.value('HR_POSITION_NAME'), 'L') = 'L' AND hapf.position_id = hpf1.position_id AND hpf1.effective_end_date = hr_general.end_of_time union all SELECT hapf.POSITION_ID ,hapf.EFFECTIVE_START_DATE ,hapf.EFFECTIVE_END_DATE ,hapf.AVAILABILITY_STATUS_ID ,hapf.BUSINESS_GROUP_ID ,hapf.ENTRY_GRADE_ID ,hapf.ENTRY_GRADE_RULE_ID ,hapf.ENTRY_STEP_ID ,hapf.JOB_ID ,hapf.LOCATION_ID ,hapf.ORGANIZATION_ID ,hapf.PAY_FREQ_PAYROLL_ID ,hpf1.position_definition_id date_effective_pos_def_id ,hapf.position_definition_id ,hapf.POSITION_TRANSACTION_ID ,hapf.PRIOR_POSITION_ID ,hapf.RELIEF_POSITION_ID ,hapf.SUCCESSOR_POSITION_ID ,hapf.SUPERVISOR_POSITION_ID ,hapf.AMENDMENT_DATE ,hapf.AMENDMENT_RECOMMENDATION ,hapf.AMENDMENT_REF_NUMBER ,hapf.BARGAINING_UNIT_CD ,hapf.COMMENTS ,hapf.CURRENT_JOB_PROP_END_DATE ,hapf.CURRENT_ORG_PROP_END_DATE ,hapf.AVAIL_STATUS_PROP_END_DATE ,hapf.DATE_EFFECTIVE ,hr_general.get_POSITION_DATE_END(hapf.position_id) ,hapf.EARLIEST_HIRE_DATE ,hapf.FILL_BY_DATE ,hapf.FREQUENCY ,hapf.FTE ,hapf.MAX_PERSONS ,hapf.name /*hr_general.decode_position_latest_NAME(position_id)*/ ,hapf.name ,hapf.OVERLAP_PERIOD ,hapf.OVERLAP_UNIT_CD ,hapf.PAY_TERM_END_DAY_CD ,hapf.PAY_TERM_END_MONTH_CD ,hapf.PERMANENT_TEMPORARY_FLAG ,hapf.PERMIT_RECRUITMENT_FLAG ,hapf.POSITION_TYPE ,hapf.POSTING_DESCRIPTION ,hapf.PROBATION_PERIOD ,hapf.PROBATION_PERIOD_UNIT_CD ,hapf.PROPOSED_FTE_FOR_LAYOFF ,hapf.PROPOSED_DATE_FOR_LAYOFF ,hapf.REPLACEMENT_REQUIRED_FLAG ,hapf.REVIEW_FLAG ,hapf.SEASONAL_FLAG ,hapf.SECURITY_REQUIREMENTS ,hapf.STATUS ,hapf.TERM_START_DAY_CD ,hapf.TERM_START_MONTH_CD ,hapf.TIME_NORMAL_FINISH ,hapf.TIME_NORMAL_START ,hapf.UPDATE_SOURCE_CD ,hapf.WORKING_HOURS ,hapf.WORKS_COUNCIL_APPROVAL_FLAG ,hapf.WORK_PERIOD_TYPE_CD ,hapf.WORK_TERM_END_DAY_CD ,hapf.WORK_TERM_END_MONTH_CD ,hapf.PAY_BASIS_ID ,hapf.SUPERVISOR_ID ,hapf.INFORMATION1 ,hapf.INFORMATION2 ,hapf.INFORMATION3 ,hapf.INFORMATION4 ,hapf.INFORMATION5 ,hapf.INFORMATION6 ,hapf.INFORMATION7 ,hapf.INFORMATION8 ,hapf.INFORMATION9 ,hapf.INFORMATION10 ,hapf.INFORMATION11 ,hapf.INFORMATION12 ,hapf.INFORMATION13 ,hapf.INFORMATION14 ,hapf.INFORMATION15 ,hapf.INFORMATION16 ,hapf.INFORMATION17 ,hapf.INFORMATION18 ,hapf.INFORMATION19 ,hapf.INFORMATION20 ,hapf.INFORMATION21 ,hapf.INFORMATION22 ,hapf.INFORMATION23 ,hapf.INFORMATION24 ,hapf.INFORMATION25 ,hapf.INFORMATION26 ,hapf.INFORMATION27 ,hapf.INFORMATION28 ,hapf.INFORMATION29 ,hapf.INFORMATION30 ,hapf.INFORMATION_CATEGORY ,hapf.ATTRIBUTE1 ,hapf.ATTRIBUTE2 ,hapf.ATTRIBUTE3 ,hapf.ATTRIBUTE4 ,hapf.ATTRIBUTE5 ,hapf.ATTRIBUTE6 ,hapf.ATTRIBUTE7 ,hapf.ATTRIBUTE8 ,hapf.ATTRIBUTE9 ,hapf.ATTRIBUTE10 ,hapf.ATTRIBUTE11 ,hapf.ATTRIBUTE12 ,hapf.ATTRIBUTE13 ,hapf.ATTRIBUTE14 ,hapf.ATTRIBUTE15 ,hapf.ATTRIBUTE16 ,hapf.ATTRIBUTE17 ,hapf.ATTRIBUTE18 ,hapf.ATTRIBUTE19 ,hapf.ATTRIBUTE20 ,hapf.ATTRIBUTE21 ,hapf.ATTRIBUTE22 ,hapf.ATTRIBUTE23 ,hapf.ATTRIBUTE24 ,hapf.ATTRIBUTE25 ,hapf.ATTRIBUTE26 ,hapf.ATTRIBUTE27 ,hapf.ATTRIBUTE28 ,hapf.ATTRIBUTE29 ,hapf.ATTRIBUTE30 ,hapf.ATTRIBUTE_CATEGORY ,hapf.REQUEST_ID ,hapf.PROGRAM_APPLICATION_ID ,hapf.PROGRAM_ID ,hapf.PROGRAM_UPDATE_DATE ,hapf.CREATED_BY ,hapf.CREATION_DATE ,hapf.LAST_UPDATED_BY ,hapf.LAST_UPDATE_DATE ,hapf.LAST_UPDATE_LOGIN ,hapf.OBJECT_VERSION_NUMBER from hr_all_positions_f hapf ,hr_all_positions_f hpf1 where nvl(fnd_profile.value('HR_POSITION_NAME'), 'L') <> 'L' AND hapf.position_id=hpf1.position_id AND hpf1.effective_end_date = hr_general.end_of_time ) hpf WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE' ,HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS' , hpf.POSITION_ID)) = 'TRUE' AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE' , HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS' ,hpf.ORGANIZATION_ID)) ='TRUE' AND decode(hr_general.get_xbg_profile ,'Y' ,hpf.business_group_id , hr_general.get_business_group_id) = hpf.business_group_id

View Text - HTML Formatted

SELECT POSITION_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, AVAILABILITY_STATUS_ID
, BUSINESS_GROUP_ID
, ENTRY_GRADE_ID
, ENTRY_GRADE_RULE_ID
, ENTRY_STEP_ID
, JOB_ID
, LOCATION_ID
, ORGANIZATION_ID
, PAY_FREQ_PAYROLL_ID
, POSITION_DEFINITION_ID
, DATE_EFFECTIVE_POS_DEF_ID
, POSITION_TRANSACTION_ID
, PRIOR_POSITION_ID
, RELIEF_POSITION_ID
, SUCCESSOR_POSITION_ID
, SUPERVISOR_POSITION_ID
, AMENDMENT_DATE
, AMENDMENT_RECOMMENDATION
, AMENDMENT_REF_NUMBER
, BARGAINING_UNIT_CD
, COMMENTS
, CURRENT_JOB_PROP_END_DATE
, CURRENT_ORG_PROP_END_DATE
, AVAIL_STATUS_PROP_END_DATE
, DATE_EFFECTIVE
, DATE_END
, EARLIEST_HIRE_DATE
, FILL_BY_DATE
, FREQUENCY
, FTE
, MAX_PERSONS
, NAME
, DATE_EFFECTIVE_NAME
, OVERLAP_PERIOD
, OVERLAP_UNIT_CD
, PAY_TERM_END_DAY_CD
, PAY_TERM_END_MONTH_CD
, PERMANENT_TEMPORARY_FLAG
, PERMIT_RECRUITMENT_FLAG
, POSITION_TYPE
, POSTING_DESCRIPTION
, PROBATION_PERIOD
, PROBATION_PERIOD_UNIT_CD
, PROPOSED_FTE_FOR_LAYOFF
, PROPOSED_DATE_FOR_LAYOFF
, REPLACEMENT_REQUIRED_FLAG
, REVIEW_FLAG
, SEASONAL_FLAG
, SECURITY_REQUIREMENTS
, STATUS
, TERM_START_DAY_CD
, TERM_START_MONTH_CD
, TIME_NORMAL_FINISH
, TIME_NORMAL_START
, UPDATE_SOURCE_CD
, WORKING_HOURS
, WORKS_COUNCIL_APPROVAL_FLAG
, WORK_PERIOD_TYPE_CD
, WORK_TERM_END_DAY_CD
, WORK_TERM_END_MONTH_CD
, PAY_BASIS_ID
, SUPERVISOR_ID
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, INFORMATION11
, INFORMATION12
, INFORMATION13
, INFORMATION14
, INFORMATION15
, INFORMATION16
, INFORMATION17
, INFORMATION18
, INFORMATION19
, INFORMATION20
, INFORMATION21
, INFORMATION22
, INFORMATION23
, INFORMATION24
, INFORMATION25
, INFORMATION26
, INFORMATION27
, INFORMATION28
, INFORMATION29
, INFORMATION30
, INFORMATION_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM ( SELECT HAPF.POSITION_ID
, HAPF.EFFECTIVE_START_DATE
, HAPF.EFFECTIVE_END_DATE
, HAPF.AVAILABILITY_STATUS_ID
, HAPF.BUSINESS_GROUP_ID
, HAPF.ENTRY_GRADE_ID
, HAPF.ENTRY_GRADE_RULE_ID
, HAPF.ENTRY_STEP_ID
, HAPF.JOB_ID
, HAPF.LOCATION_ID
, HAPF.ORGANIZATION_ID
, HAPF.PAY_FREQ_PAYROLL_ID
, HPF1.POSITION_DEFINITION_ID DATE_EFFECTIVE_POS_DEF_ID
, HAPF.POSITION_DEFINITION_ID
, HAPF.POSITION_TRANSACTION_ID
, HAPF.PRIOR_POSITION_ID
, HAPF.RELIEF_POSITION_ID
, HAPF.SUCCESSOR_POSITION_ID
, HAPF.SUPERVISOR_POSITION_ID
, HAPF.AMENDMENT_DATE
, HAPF.AMENDMENT_RECOMMENDATION
, HAPF.AMENDMENT_REF_NUMBER
, HAPF.BARGAINING_UNIT_CD
, HAPF.COMMENTS
, HAPF.CURRENT_JOB_PROP_END_DATE
, HAPF.CURRENT_ORG_PROP_END_DATE
, HAPF.AVAIL_STATUS_PROP_END_DATE
, HAPF.DATE_EFFECTIVE
, HR_GENERAL.GET_POSITION_DATE_END(HAPF.POSITION_ID) DATE_END
, HAPF.EARLIEST_HIRE_DATE
, HAPF.FILL_BY_DATE
, HAPF.FREQUENCY
, HAPF.FTE
, HAPF.MAX_PERSONS
, PFT.NAME /*
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(HAPF.POSITION_ID)*/
, HAPF.NAME DATE_EFFECTIVE_NAME
, HAPF.OVERLAP_PERIOD
, HAPF.OVERLAP_UNIT_CD
, HAPF.PAY_TERM_END_DAY_CD
, HAPF.PAY_TERM_END_MONTH_CD
, HAPF.PERMANENT_TEMPORARY_FLAG
, HAPF.PERMIT_RECRUITMENT_FLAG
, HAPF.POSITION_TYPE
, HAPF.POSTING_DESCRIPTION
, HAPF.PROBATION_PERIOD
, HAPF.PROBATION_PERIOD_UNIT_CD
, HAPF.PROPOSED_FTE_FOR_LAYOFF
, HAPF.PROPOSED_DATE_FOR_LAYOFF
, HAPF.REPLACEMENT_REQUIRED_FLAG
, HAPF.REVIEW_FLAG
, HAPF.SEASONAL_FLAG
, HAPF.SECURITY_REQUIREMENTS
, HAPF.STATUS
, HAPF.TERM_START_DAY_CD
, HAPF.TERM_START_MONTH_CD
, HAPF.TIME_NORMAL_FINISH
, HAPF.TIME_NORMAL_START
, HAPF.UPDATE_SOURCE_CD
, HAPF.WORKING_HOURS
, HAPF.WORKS_COUNCIL_APPROVAL_FLAG
, HAPF.WORK_PERIOD_TYPE_CD
, HAPF.WORK_TERM_END_DAY_CD
, HAPF.WORK_TERM_END_MONTH_CD
, HAPF.PAY_BASIS_ID
, HAPF.SUPERVISOR_ID
, HAPF.INFORMATION1
, HAPF.INFORMATION2
, HAPF.INFORMATION3
, HAPF.INFORMATION4
, HAPF.INFORMATION5
, HAPF.INFORMATION6
, HAPF.INFORMATION7
, HAPF.INFORMATION8
, HAPF.INFORMATION9
, HAPF.INFORMATION10
, HAPF.INFORMATION11
, HAPF.INFORMATION12
, HAPF.INFORMATION13
, HAPF.INFORMATION14
, HAPF.INFORMATION15
, HAPF.INFORMATION16
, HAPF.INFORMATION17
, HAPF.INFORMATION18
, HAPF.INFORMATION19
, HAPF.INFORMATION20
, HAPF.INFORMATION21
, HAPF.INFORMATION22
, HAPF.INFORMATION23
, HAPF.INFORMATION24
, HAPF.INFORMATION25
, HAPF.INFORMATION26
, HAPF.INFORMATION27
, HAPF.INFORMATION28
, HAPF.INFORMATION29
, HAPF.INFORMATION30
, HAPF.INFORMATION_CATEGORY
, HAPF.ATTRIBUTE1
, HAPF.ATTRIBUTE2
, HAPF.ATTRIBUTE3
, HAPF.ATTRIBUTE4
, HAPF.ATTRIBUTE5
, HAPF.ATTRIBUTE6
, HAPF.ATTRIBUTE7
, HAPF.ATTRIBUTE8
, HAPF.ATTRIBUTE9
, HAPF.ATTRIBUTE10
, HAPF.ATTRIBUTE11
, HAPF.ATTRIBUTE12
, HAPF.ATTRIBUTE13
, HAPF.ATTRIBUTE14
, HAPF.ATTRIBUTE15
, HAPF.ATTRIBUTE16
, HAPF.ATTRIBUTE17
, HAPF.ATTRIBUTE18
, HAPF.ATTRIBUTE19
, HAPF.ATTRIBUTE20
, HAPF.ATTRIBUTE21
, HAPF.ATTRIBUTE22
, HAPF.ATTRIBUTE23
, HAPF.ATTRIBUTE24
, HAPF.ATTRIBUTE25
, HAPF.ATTRIBUTE26
, HAPF.ATTRIBUTE27
, HAPF.ATTRIBUTE28
, HAPF.ATTRIBUTE29
, HAPF.ATTRIBUTE30
, HAPF.ATTRIBUTE_CATEGORY
, HAPF.REQUEST_ID
, HAPF.PROGRAM_APPLICATION_ID
, HAPF.PROGRAM_ID
, HAPF.PROGRAM_UPDATE_DATE
, HAPF.CREATED_BY
, HAPF.CREATION_DATE
, HAPF.LAST_UPDATED_BY
, HAPF.LAST_UPDATE_DATE
, HAPF.LAST_UPDATE_LOGIN
, HAPF.OBJECT_VERSION_NUMBER
FROM HR_ALL_POSITIONS_F HAPF
, HR_ALL_POSITIONS_F HPF1
, HR_ALL_POSITIONS_F_TL PFT
WHERE PFT.POSITION_ID = HAPF.POSITION_ID
AND PFT.LANGUAGE = USERENV('LANG')
AND NVL(FND_PROFILE.VALUE('HR_POSITION_NAME')
, 'L') = 'L'
AND HAPF.POSITION_ID = HPF1.POSITION_ID
AND HPF1.EFFECTIVE_END_DATE = HR_GENERAL.END_OF_TIME UNION ALL SELECT HAPF.POSITION_ID
, HAPF.EFFECTIVE_START_DATE
, HAPF.EFFECTIVE_END_DATE
, HAPF.AVAILABILITY_STATUS_ID
, HAPF.BUSINESS_GROUP_ID
, HAPF.ENTRY_GRADE_ID
, HAPF.ENTRY_GRADE_RULE_ID
, HAPF.ENTRY_STEP_ID
, HAPF.JOB_ID
, HAPF.LOCATION_ID
, HAPF.ORGANIZATION_ID
, HAPF.PAY_FREQ_PAYROLL_ID
, HPF1.POSITION_DEFINITION_ID DATE_EFFECTIVE_POS_DEF_ID
, HAPF.POSITION_DEFINITION_ID
, HAPF.POSITION_TRANSACTION_ID
, HAPF.PRIOR_POSITION_ID
, HAPF.RELIEF_POSITION_ID
, HAPF.SUCCESSOR_POSITION_ID
, HAPF.SUPERVISOR_POSITION_ID
, HAPF.AMENDMENT_DATE
, HAPF.AMENDMENT_RECOMMENDATION
, HAPF.AMENDMENT_REF_NUMBER
, HAPF.BARGAINING_UNIT_CD
, HAPF.COMMENTS
, HAPF.CURRENT_JOB_PROP_END_DATE
, HAPF.CURRENT_ORG_PROP_END_DATE
, HAPF.AVAIL_STATUS_PROP_END_DATE
, HAPF.DATE_EFFECTIVE
, HR_GENERAL.GET_POSITION_DATE_END(HAPF.POSITION_ID)
, HAPF.EARLIEST_HIRE_DATE
, HAPF.FILL_BY_DATE
, HAPF.FREQUENCY
, HAPF.FTE
, HAPF.MAX_PERSONS
, HAPF.NAME /*HR_GENERAL.DECODE_POSITION_LATEST_NAME(POSITION_ID)*/
, HAPF.NAME
, HAPF.OVERLAP_PERIOD
, HAPF.OVERLAP_UNIT_CD
, HAPF.PAY_TERM_END_DAY_CD
, HAPF.PAY_TERM_END_MONTH_CD
, HAPF.PERMANENT_TEMPORARY_FLAG
, HAPF.PERMIT_RECRUITMENT_FLAG
, HAPF.POSITION_TYPE
, HAPF.POSTING_DESCRIPTION
, HAPF.PROBATION_PERIOD
, HAPF.PROBATION_PERIOD_UNIT_CD
, HAPF.PROPOSED_FTE_FOR_LAYOFF
, HAPF.PROPOSED_DATE_FOR_LAYOFF
, HAPF.REPLACEMENT_REQUIRED_FLAG
, HAPF.REVIEW_FLAG
, HAPF.SEASONAL_FLAG
, HAPF.SECURITY_REQUIREMENTS
, HAPF.STATUS
, HAPF.TERM_START_DAY_CD
, HAPF.TERM_START_MONTH_CD
, HAPF.TIME_NORMAL_FINISH
, HAPF.TIME_NORMAL_START
, HAPF.UPDATE_SOURCE_CD
, HAPF.WORKING_HOURS
, HAPF.WORKS_COUNCIL_APPROVAL_FLAG
, HAPF.WORK_PERIOD_TYPE_CD
, HAPF.WORK_TERM_END_DAY_CD
, HAPF.WORK_TERM_END_MONTH_CD
, HAPF.PAY_BASIS_ID
, HAPF.SUPERVISOR_ID
, HAPF.INFORMATION1
, HAPF.INFORMATION2
, HAPF.INFORMATION3
, HAPF.INFORMATION4
, HAPF.INFORMATION5
, HAPF.INFORMATION6
, HAPF.INFORMATION7
, HAPF.INFORMATION8
, HAPF.INFORMATION9
, HAPF.INFORMATION10
, HAPF.INFORMATION11
, HAPF.INFORMATION12
, HAPF.INFORMATION13
, HAPF.INFORMATION14
, HAPF.INFORMATION15
, HAPF.INFORMATION16
, HAPF.INFORMATION17
, HAPF.INFORMATION18
, HAPF.INFORMATION19
, HAPF.INFORMATION20
, HAPF.INFORMATION21
, HAPF.INFORMATION22
, HAPF.INFORMATION23
, HAPF.INFORMATION24
, HAPF.INFORMATION25
, HAPF.INFORMATION26
, HAPF.INFORMATION27
, HAPF.INFORMATION28
, HAPF.INFORMATION29
, HAPF.INFORMATION30
, HAPF.INFORMATION_CATEGORY
, HAPF.ATTRIBUTE1
, HAPF.ATTRIBUTE2
, HAPF.ATTRIBUTE3
, HAPF.ATTRIBUTE4
, HAPF.ATTRIBUTE5
, HAPF.ATTRIBUTE6
, HAPF.ATTRIBUTE7
, HAPF.ATTRIBUTE8
, HAPF.ATTRIBUTE9
, HAPF.ATTRIBUTE10
, HAPF.ATTRIBUTE11
, HAPF.ATTRIBUTE12
, HAPF.ATTRIBUTE13
, HAPF.ATTRIBUTE14
, HAPF.ATTRIBUTE15
, HAPF.ATTRIBUTE16
, HAPF.ATTRIBUTE17
, HAPF.ATTRIBUTE18
, HAPF.ATTRIBUTE19
, HAPF.ATTRIBUTE20
, HAPF.ATTRIBUTE21
, HAPF.ATTRIBUTE22
, HAPF.ATTRIBUTE23
, HAPF.ATTRIBUTE24
, HAPF.ATTRIBUTE25
, HAPF.ATTRIBUTE26
, HAPF.ATTRIBUTE27
, HAPF.ATTRIBUTE28
, HAPF.ATTRIBUTE29
, HAPF.ATTRIBUTE30
, HAPF.ATTRIBUTE_CATEGORY
, HAPF.REQUEST_ID
, HAPF.PROGRAM_APPLICATION_ID
, HAPF.PROGRAM_ID
, HAPF.PROGRAM_UPDATE_DATE
, HAPF.CREATED_BY
, HAPF.CREATION_DATE
, HAPF.LAST_UPDATED_BY
, HAPF.LAST_UPDATE_DATE
, HAPF.LAST_UPDATE_LOGIN
, HAPF.OBJECT_VERSION_NUMBER
FROM HR_ALL_POSITIONS_F HAPF
, HR_ALL_POSITIONS_F HPF1
WHERE NVL(FND_PROFILE.VALUE('HR_POSITION_NAME')
, 'L') <> 'L'
AND HAPF.POSITION_ID=HPF1.POSITION_ID
AND HPF1.EFFECTIVE_END_DATE = HR_GENERAL.END_OF_TIME ) HPF
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS'
, HPF.POSITION_ID)) = 'TRUE'
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HPF.ORGANIZATION_ID)) ='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HPF.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HPF.BUSINESS_GROUP_ID