[Home] [Help]
View: PA_FP_PERIODS_PL_V
| Product: | PA - Projects |
| Description: | The pa_fp_periods_pl_v view is created for the start period poplist. |
| Implementation/DBA Data: |
APPS.PA_FP_PERIODS_PL_V
|
View Text
SELECT PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NAME
, START_DATE
, END_DATE
FROM PA_ORGFCST_PERIODS_TMP_V
WHERE START_DATE >=PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_START_DATE()
AND END_DATE <= PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_END_DATE()
Columns
| Name |
| PERIOD_TYPE |
| PERIOD_YEAR |
| PERIOD_NAME |
| START_DATE |
| END_DATE |