Product: | PER - Human Resources |
---|---|
Description: | To support User Interface. |
Implementation/DBA Data: | APPS.HR_POSITIONS_V1 |
SELECT PSF.ROWID
, PSF.POSITION_ID
, PSF.EFFECTIVE_START_DATE
, PSF.EFFECTIVE_END_DATE
, PSF.AVAILABILITY_STATUS_ID
, HR_GENERAL.DECODE_AVAILABILITY_STATUS(PSF.AVAILABILITY_STATUS_ID) AVAILABILITY_STATUS_DESC
, HR_GENERAL.DECODE_AVAIL_STATUS_START_DATE( PSF.POSITION_ID
, PSF.AVAILABILITY_STATUS_ID
, PSF.EFFECTIVE_START_DATE) AVAILABILITY_STATUS_START_DATE
, PSF.BUSINESS_GROUP_ID
, PSF.ENTRY_STEP_ID
, HR_GENERAL.DECODE_STEP(PSF.ENTRY_STEP_ID
, DATE_EFFECTIVE) ENTRY_STEP_DESC
, PSF.ENTRY_GRADE_RULE_ID
, HR_GENERAL.DECODE_GRADE_RULE(PSF.ENTRY_GRADE_RULE_ID) GRADE_RATE_VALUE
, PGR.VALUE POINT_VALUE
, PGR.MINIMUM GRADE_RATE_MIN
, PGR.MID_VALUE GRADE_RATE_MID
, PGR.MAXIMUM GRADE_RATE_MAX
, PSF.JOB_ID
, HR_GENERAL.DECODE_JOB(PSF.JOB_ID) JOB_DESC
, PSF.LOCATION_ID
, HR_GENERAL.DECODE_LOCATION(PSF.LOCATION_ID) LOCATION_DESC
, PSF.ORGANIZATION_ID
, HR_GENERAL.DECODE_ORGANIZATION(PSF.ORGANIZATION_ID) ORGANIZATION_DESC
, PSF.PAY_FREQ_PAYROLL_ID
, HR_GENERAL.DECODE_PAYROLL(PSF.PAY_FREQ_PAYROLL_ID) PAY_FREQ_PAYROLL_DESC
, PSF.POSITION_DEFINITION_ID
, PSF.POSITION_TRANSACTION_ID
, PSF.PRIOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.PRIOR_POSITION_ID) PRIOR_POSITION_DESC
, PSF.RELIEF_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.RELIEF_POSITION_ID) RELIEF_POSITION_DESC
, PSF.ENTRY_GRADE_ID
, HR_GENERAL.DECODE_GRADE(PSF.ENTRY_GRADE_ID) SALARY_ENTRY_GRADE_DESC
, PSF.SUCCESSOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.SUCCESSOR_POSITION_ID) SUCCESSOR_POSITION_DESC
, PSF.SUPERVISOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.SUPERVISOR_POSITION_ID) SUPERVISOR_POSITION_DESC
, PSF.AMENDMENT_DATE
, PSF.AMENDMENT_RECOMMENDATION
, PSF.AMENDMENT_REF_NUMBER
, PSF.BARGAINING_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP( 'BARGAINING_UNIT_CODE'
, PSF.BARGAINING_UNIT_CD) BARGAINING_UNIT_DESC
, PSF.COMMENTS
, PSF.CURRENT_JOB_PROP_END_DATE
, PSF.CURRENT_ORG_PROP_END_DATE
, PSF.AVAIL_STATUS_PROP_END_DATE
, PSF.DATE_EFFECTIVE
, PSF.DATE_END
, PSF.EARLIEST_HIRE_DATE
, PSF.FILL_BY_DATE
, PSF.FREQUENCY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PSF.FREQUENCY) FREQUENCY_DESC
, PSF.FTE
, PSF.MAX_PERSONS
, PSF.NAME
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PSF.POSITION_ID) POSITION_LATEST_NAME
, HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID(PSF.POSITION_ID) LATEST_POSITION_DEFINITION_ID
, PSF.OVERLAP_PERIOD
, PSF.OVERLAP_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP( 'FREQUENCY'
, PSF.OVERLAP_UNIT_CD) OVERLAP_UNIT_DESC
, PSF.PAY_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.PAY_TERM_END_DAY_CD) PAY_TERM_END_DAY_DESC
, PSF.PAY_TERM_END_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.PAY_TERM_END_MONTH_CD) PAY_TERM_END_MONTH_DESC
, PSF.PERMANENT_TEMPORARY_FLAG
, PSF.PERMIT_RECRUITMENT_FLAG
, PSF.POSITION_TYPE
, HR_GENERAL.DECODE_LOOKUP('POSITION_TYPE'
, PSF.POSITION_TYPE) POSITION_TYPE_DESC
, PSF.POSTING_DESCRIPTION
, PSF.PROBATION_PERIOD
, PSF.PROBATION_PERIOD_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PSF.PROBATION_PERIOD_UNIT_CD) PROBATION_UNIT_DESC
, PSF.REPLACEMENT_REQUIRED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PSF.REPLACEMENT_REQUIRED_FLAG) REPLACEMENT_REQUIRED_DESC
, PSF.REVIEW_FLAG
, PSF.SEASONAL_FLAG
, PSF.SECURITY_REQUIREMENTS
, PSF.STATUS
, HR_GENERAL.DECODE_LOOKUP('POSITION_STATUS'
, PSF.STATUS) STATUS_DESC
, PSF.TERM_START_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.TERM_START_DAY_CD) TERM_START_DAY_DESC
, PSF.TERM_START_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.TERM_START_MONTH_CD) TERM_START_MONTH
, PSF.TIME_NORMAL_FINISH
, PSF.TIME_NORMAL_START
, PSF.UPDATE_SOURCE_CD
, PSF.WORKING_HOURS
, PSF.WORKS_COUNCIL_APPROVAL_FLAG
, PSF.WORK_PERIOD_TYPE_CD
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PSF.WORK_PERIOD_TYPE_CD) WORK_PERIOD_TYPE_DESC
, PSF.WORK_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_DAY_DESC
, PSF.WORK_TERM_END_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_MONTH_DESC
, PSF.PROPOSED_FTE_FOR_LAYOFF
, PSF.PROPOSED_DATE_FOR_LAYOFF
, HR_GENERAL.DECODE_PAY_BASIS(PSF.PAY_BASIS_ID) PAY_BASIS_DESC
, PSF.PAY_BASIS_ID
, HR_GENERAL.DECODE_PERSON_NAME(PSF.SUPERVISOR_ID) SUPERVISOR_NAME
, PSF.SUPERVISOR_ID
, PSF.INFORMATION1
, PSF.INFORMATION2
, PSF.INFORMATION3
, PSF.INFORMATION4
, PSF.INFORMATION5
, PSF.INFORMATION6
, PSF.INFORMATION7
, PSF.INFORMATION8
, PSF.INFORMATION9
, PSF.INFORMATION10
, PSF.INFORMATION11
, PSF.INFORMATION12
, PSF.INFORMATION13
, PSF.INFORMATION14
, PSF.INFORMATION15
, PSF.INFORMATION16
, PSF.INFORMATION17
, PSF.INFORMATION18
, PSF.INFORMATION19
, PSF.INFORMATION20
, PSF.INFORMATION21
, PSF.INFORMATION22
, PSF.INFORMATION23
, PSF.INFORMATION24
, PSF.INFORMATION25
, PSF.INFORMATION26
, PSF.INFORMATION27
, PSF.INFORMATION28
, PSF.INFORMATION29
, PSF.INFORMATION30
, PSF.INFORMATION_CATEGORY
, PSF.ATTRIBUTE1
, PSF.ATTRIBUTE2
, PSF.ATTRIBUTE3
, PSF.ATTRIBUTE4
, PSF.ATTRIBUTE5
, PSF.ATTRIBUTE6
, PSF.ATTRIBUTE7
, PSF.ATTRIBUTE8
, PSF.ATTRIBUTE9
, PSF.ATTRIBUTE10
, PSF.ATTRIBUTE11
, PSF.ATTRIBUTE12
, PSF.ATTRIBUTE13
, PSF.ATTRIBUTE14
, PSF.ATTRIBUTE15
, PSF.ATTRIBUTE16
, PSF.ATTRIBUTE17
, PSF.ATTRIBUTE18
, PSF.ATTRIBUTE19
, PSF.ATTRIBUTE20
, PSF.ATTRIBUTE21
, PSF.ATTRIBUTE22
, PSF.ATTRIBUTE23
, PSF.ATTRIBUTE24
, PSF.ATTRIBUTE25
, PSF.ATTRIBUTE26
, PSF.ATTRIBUTE27
, PSF.ATTRIBUTE28
, PSF.ATTRIBUTE29
, PSF.ATTRIBUTE30
, PSF.ATTRIBUTE_CATEGORY
, PSF.REQUEST_ID
, PSF.PROGRAM_APPLICATION_ID
, PSF.PROGRAM_ID
, PSF.PROGRAM_UPDATE_DATE
, PSF.CREATED_BY
, PSF.CREATION_DATE
, PSF.LAST_UPDATED_BY
, PSF.LAST_UPDATE_DATE
, PSF.LAST_UPDATE_LOGIN
, PSF.OBJECT_VERSION_NUMBER
FROM HR_POSITIONS_F PSF
, PAY_GRADE_RULES PGR
WHERE PSF.ENTRY_GRADE_RULE_ID = PGR.GRADE_RULE_ID(+)
AND PSF.EFFECTIVE_END_DATE = TO_DATE('12/31/4712'
, 'MM/DD/YYYY')