View: PA_PERIODS_COPY_V

Product:	PA - Projects
Description:	View to determine which PA periods to copy from GL periods.
Implementation/DBA Data:	APPS.PA_PERIODS_COPY_V

View Text

SELECT GLP.PERIOD_NAME
, GLP.START_DATE
, GLP.END_DATE
, GLP2.PERIOD_NAME
, GLB.SET_OF_BOOKS_ID
, IMP.ORG_ID
FROM GL_PERIODS GLP2
, GL_PERIODS GLP
, GL_SETS_OF_BOOKS GLB
, PA_IMPLEMENTATIONS IMP
WHERE GLB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GLP.PERIOD_SET_NAME = IMP.PERIOD_SET_NAME
AND GLB.PERIOD_SET_NAME = GLP2.PERIOD_SET_NAME
AND GLP.PERIOD_TYPE = IMP.PA_PERIOD_TYPE
AND GLP2.PERIOD_TYPE = GLB.ACCOUNTED_PERIOD_TYPE
AND GLP.END_DATE BETWEEN GLP2.START_DATE
AND GLP2.END_DATE
AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GLP2.ADJUSTMENT_PERIOD_FLAG = 'N'
AND NOT EXISTS ( SELECT NULL
FROM PA_PERIODS
WHERE PERIOD_NAME = GLP.PERIOD_NAME )

Columns