View: PAFV_ACCOUNTING_PERIODS

Product:	PA - Projects
Description:	Business view to show information about PA periods.
Implementation/DBA Data:	APPS.PAFV_ACCOUNTING_PERIODS

View Text

SELECT PPA.PERIOD_NAME
, PPA.GL_PERIOD_NAME
, PPA.ORG_ID
, TL.NAME
, '_LA:STATUS:PA_LOOKUPS:CLOSING STATUS:MEANING'
, PPA.START_DATE
, PPA.END_DATE
, '_LA:CURRENT_PA_PERIOD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
FROM PA_PERIODS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS_TL TL
FROM PA_PERIODS_ALL PPA
WHERE PPA.ORG_ID = TL.ORGANIZATION_ID(+)
AND TL.LANGUAGE = USERENV('LANG')
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns