Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBBV_BUDGET_WORKSHEETS |
SELECT WS.NAME
, '_LA:WORKSHEET_TYPE:FND_LOOKUPS:PSB_WORKSHEET_TYPES:MEANING'
, WS.DESCRIPTION
, WS.CURRENT_STAGE_SEQ
, WS.BUDGET_BY_POSITION
, WS.NUM_PROPOSED_YEARS
, WS.NUM_YEARS_TO_ALLOCATE
, WS.ROUNDING_FACTOR
, WS.GL_CUTOFF_PERIOD
, WS.USE_REVISED_ELEMENT_RATES
, WS.INCLUDE_TRANSLATED_BALANCE
, WS.INCLUDE_ADJUSTMENT_PERIODS
, WS.INCLUDE_STAT_BALANCE
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, WS.WORKSHEET_ID
, WS.BUDGET_GROUP_ID
, WS.BUDGET_CALENDAR_ID
, WS.STAGE_SET_ID
, WS.GLOBAL_WORKSHEET_ID
, WS.GL_BUDGET_SET_ID
, WS.BUDGET_VERSION_ID
, WS.DATA_EXTRACT_ID
, WS.PARAMETER_SET_ID
, WS.CONSTRAINT_SET_ID
, WS.ALLOCRULE_SET_ID
, WS.FREEZE_FLAG
, WS.LAST_UPDATED_BY
, WS.LAST_UPDATE_DATE
, WS.CREATION_DATE
, WS.CREATED_BY
FROM PSB_WORKSHEETS WS
WHERE WS.BUDGET_GROUP_ID IN ( SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUPS
WHERE BUDGET_GROUP_TYPE = 'R'
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE) START WITH BUDGET_GROUP_ID IN (SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUP_RESP
WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID) CONNECT BY PRIOR BUDGET_GROUP_ID = PARENT_BUDGET_GROUP_ID ) WITH READ ONLY