[Home] [Help]
View: PSBFV_BUDGET_PERIODS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BP1.NAME
, BP1.DESCRIPTION
, BP1.START_DATE
, BP1.END_DATE
, BP2.NAME
, BP1.BUDGET_PERIOD_ID
, BP2.BUDGET_PERIOD_ID
, BP1.LAST_UPDATE_DATE
, BP1.LAST_UPDATED_BY
, BP1.CREATED_BY
, BP1.CREATION_DATE
FROM PSB_BUDGET_PERIODS BP1
, PSB_BUDGET_PERIODS BP2
WHERE BP1.PARENT_BUDGET_PERIOD_ID=BP2.BUDGET_PERIOD_ID
AND BP1.BUDGET_PERIOD_TYPE = 'P' WITH READ ONLY
Columns
Name |
BUDGET_PERIOD_NAME |
BUDGET_PERIOD_DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
BUDGET_YEAR_NAME |
BUDGET_PERIOD_ID |
BUDGET_YEAR_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |