VIEW: APPS.PAY_CALENDARS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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