VIEW: APPS.PER_TIME_PERIODS_V

Source

View Text - Preformatted

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 ,TPE.payslip_view_date FROM PER_TIME_PERIODS TPE, HR_LOOKUPS HL WHERE HL.LOOKUP_CODE = TPE.STATUS AND HL.LOOKUP_TYPE = 'PROCESSING_PERIOD_STATUS'

View Text - HTML Formatted

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
, TPE.PAYSLIP_VIEW_DATE
FROM PER_TIME_PERIODS TPE
, HR_LOOKUPS HL
WHERE HL.LOOKUP_CODE = TPE.STATUS
AND HL.LOOKUP_TYPE = 'PROCESSING_PERIOD_STATUS'