Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_CALENDARS_V |
SELECT CAL.ROWID ROW_ID
, TPT.DISPLAY_PERIOD_TYPE
, CAL.PERIOD_SET_NAME
, CAL.ACTUAL_PERIOD_TYPE
, CAL.PROC_PERIOD_TYPE
, CAL.START_DATE
, CAL.COMMENTS
, CAL.ATTRIBUTE_CATEGORY
, CAL.ATTRIBUTE1
, CAL.ATTRIBUTE2
, CAL.ATTRIBUTE3
, CAL.ATTRIBUTE4
, CAL.ATTRIBUTE5
, CAL.ATTRIBUTE6
, CAL.ATTRIBUTE7
, CAL.ATTRIBUTE8
, CAL.ATTRIBUTE9
, CAL.ATTRIBUTE10
, CAL.ATTRIBUTE11
, CAL.ATTRIBUTE12
, CAL.ATTRIBUTE13
, CAL.ATTRIBUTE14
, CAL.ATTRIBUTE15
, CAL.ATTRIBUTE16
, CAL.ATTRIBUTE17
, CAL.ATTRIBUTE18
, CAL.ATTRIBUTE19
, CAL.ATTRIBUTE20
, CAL.LAST_UPDATE_DATE
, CAL.LAST_UPDATED_BY
, CAL.LAST_UPDATE_LOGIN
, CAL.CREATED_BY
, CAL.CREATION_DATE
, TPT.NUMBER_PER_FISCAL_YEAR
FROM PAY_CALENDARS CAL
, PER_TIME_PERIOD_TYPES_VL TPT
WHERE TPT.PERIOD_TYPE = CAL.ACTUAL_PERIOD_TYPE