Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_TIME_PERIODS_V |
SELECT TPE.ROWID ROW_ID
, TPE.TIME_PERIOD_ID
, TPE.PAYROLL_ID
, TPE.END_DATE
, TPE.PERIOD_NAME
, TPE.PERIOD_NUM
, TPE.PERIOD_TYPE
, TPE.START_DATE
, TPE.CUT_OFF_DATE
, TPE.DEFAULT_DD_DATE
, TPE.DESCRIPTION
, TPE.PAY_ADVICE_DATE
, TPE.PERIOD_SET_NAME
, TPE.PERIOD_YEAR
, TPE.PROC_PERIOD_TYPE
, TPE.QUARTER_NUM
, TPE.QUICKPAY_DISPLAY_NUMBER
, TPE.REGULAR_PAYMENT_DATE
, TPE.RUN_DISPLAY_NUMBER
, TPE.STATUS
, TPE.YEAR_NUMBER
, TPE.ATTRIBUTE_CATEGORY
, TPE.ATTRIBUTE1
, TPE.ATTRIBUTE2
, TPE.ATTRIBUTE3
, TPE.ATTRIBUTE4
, TPE.ATTRIBUTE5
, TPE.ATTRIBUTE6
, TPE.ATTRIBUTE7
, TPE.ATTRIBUTE8
, TPE.ATTRIBUTE9
, TPE.ATTRIBUTE10
, TPE.ATTRIBUTE11
, TPE.ATTRIBUTE12
, TPE.ATTRIBUTE13
, TPE.ATTRIBUTE14
, TPE.ATTRIBUTE15
, TPE.ATTRIBUTE16
, TPE.ATTRIBUTE17
, TPE.ATTRIBUTE18
, TPE.ATTRIBUTE19
, TPE.ATTRIBUTE20
, TPE.LAST_UPDATE_DATE
, TPE.LAST_UPDATED_BY
, TPE.LAST_UPDATE_LOGIN
, TPE.CREATED_BY
, TPE.CREATION_DATE
, TPE.PRD_INFORMATION_CATEGORY
, TPE.PRD_INFORMATION1
, TPE.PRD_INFORMATION2
, TPE.PRD_INFORMATION3
, TPE.PRD_INFORMATION4
, TPE.PRD_INFORMATION5
, TPE.PRD_INFORMATION6
, TPE.PRD_INFORMATION7
, TPE.PRD_INFORMATION8
, TPE.PRD_INFORMATION9
, TPE.PRD_INFORMATION10
, TPE.PRD_INFORMATION11
, TPE.PRD_INFORMATION12
, TPE.PRD_INFORMATION13
, TPE.PRD_INFORMATION14
, TPE.PRD_INFORMATION15
, TPE.PRD_INFORMATION16
, TPE.PRD_INFORMATION17
, TPE.PRD_INFORMATION18
, TPE.PRD_INFORMATION19
, TPE.PRD_INFORMATION20
, TPE.PRD_INFORMATION21
, TPE.PRD_INFORMATION22
, TPE.PRD_INFORMATION23
, TPE.PRD_INFORMATION24
, TPE.PRD_INFORMATION25
, TPE.PRD_INFORMATION26
, TPE.PRD_INFORMATION27
, TPE.PRD_INFORMATION28
, TPE.PRD_INFORMATION29
, TPE.PRD_INFORMATION30
, HL.MEANING D_STATUS
FROM PER_TIME_PERIODS TPE
, HR_LOOKUPS HL
WHERE HL.LOOKUP_CODE = TPE.STATUS
AND HL.LOOKUP_TYPE = 'PROCESSING_PERIOD_STATUS'