View: PA_REP_YEAR_PA_V

Product:	PA - Projects
Description:	PA_REP_YEAR_PA_V is a view to get PA year numbers
Implementation/DBA Data:	APPS.PA_REP_YEAR_PA_V

View Text

SELECT DISTINCT GLPER.PERIOD_YEAR PERIOD_YEAR
, IMP.ORG_ID
FROM PA_IMPLEMENTATIONS IMP
, GL_PERIODS GLPER
WHERE IMP.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND IMP.PA_PERIOD_TYPE = GLPER.PERIOD_TYPE

Columns