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, 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, 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
, 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
, 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