View: PA_FP_PERIODS_TMP_V

Product:	PA - Projects
Description:	The PA_FP_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates.
Implementation/DBA Data:	APPS.PA_FP_PERIODS_TMP_V

View Text

SELECT DISTINCT PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, PAPERIOD.PERIOD_YEAR
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PERIOD_NAME
, 'GL'
, GL_PERIOD_NAME)
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PA_START_DATE
, 'GL'
, GL_START_DATE)
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PA_END_DATE
, 'GL'
, GL_END_DATE)
FROM PA_PERIODS_V PAPERIOD
, PA_BUDGET_VERSIONS PBV
WHERE PBV.BUDGET_VERSION_ID = PA_FP_VIEW_PLANS_PUB.GET_VERSION_ID()

Columns