Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_YEAR_PROFILES_V |
SELECT WUP.ROWID
, WUP.WORKSHEET_ID
, WUP.USER_ID
, WUP.PROFILE_TYPE
, YTP.YEAR_CATEGORY_TYPE
, YTP.NAME
, WUP.BUDGET_PERIOD_ID
, BP.NAME
, YTP.SEQUENCE_NUMBER
, WUP.FTE_FLAG
, WUP.ACTUAL_FLAG
, WUP.BUDGET_FLAG
, WUP.ESTIMATE_FLAG
, WUP.ENCUMBRANCE_FLAG
, WUP.START_YEAR_FLAG
, WUP.LAST_UPDATE_DATE
, WUP.LAST_UPDATED_BY
, WUP.LAST_UPDATE_LOGIN
, WUP.CREATED_BY
, WUP.CREATION_DATE
FROM PSB_WS_USER_PROFILES WUP
, PSB_BUDGET_PERIODS BP
, PSB_BUDGET_YEAR_TYPES YTP
WHERE WUP.BUDGET_PERIOD_ID = BP.BUDGET_PERIOD_ID(+)
AND BP.BUDGET_YEAR_TYPE_ID = YTP.BUDGET_YEAR_TYPE_ID(+)
AND WUP.PROFILE_TYPE = 'Y'