Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_BUDGET_YEARS |
SELECT BP1.NAME
, BP1.DESCRIPTION
, BP1.START_DATE
, BP1.END_DATE
, '_LA:PERIOD_DISTRIBUTION_TYPE:FND_LOOKUPS:PSB_PERIOD_DISTRIBUTION_TYPES:MEANING'
, '_LA:CALCULATION_PERIOD_TYPE:FND_LOOKUPS:PSB_CALCULATION_PERIOD_TYPES:MEANING'
, '_DF:PSB:PSB_BUDGET_PERIODS:BP1'
, BC.NAME
, BYTP1.YEAR_CATEGORY_TYPE
, BYTP1.NAME
, BP1.BUDGET_PERIOD_ID
, BP1.BUDGET_CALENDAR_ID
, BP1.BUDGET_YEAR_TYPE_ID
, BP1.LAST_UPDATE_DATE
, BP1.LAST_UPDATED_BY
, BP1.CREATED_BY
, BP1.CREATION_DATE
FROM PSB_BUDGET_PERIODS BP1
, PSB_BUDGET_CALENDARS BC
, PSB_BUDGET_YEAR_TYPES BYTP1
WHERE BP1.BUDGET_PERIOD_TYPE = 'Y'
AND BP1.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID
AND BYTP1.BUDGET_YEAR_TYPE_ID = BP1.BUDGET_YEAR_TYPE_ID WITH READ ONLY