View: PER_BUDGETS_LOV

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_BUDGETS_LOV

View Text

SELECT B.NAME
, HR1.MEANING
, B.UNIT
, B.BUDGET_ID
, B.PERIOD_SET_NAME
, B.BUSINESS_GROUP_ID
, BV1.VERSION_NUMBER
, BV1.BUDGET_VERSION_ID
, BV1.DATE_FROM
, NVL(BV1.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY')) DATE_TO
, BE.POSITION_ID
, BE.ORGANIZATION_ID
FROM PER_BUDGETS B
, HR_LOOKUPS HR1
, PER_BUDGET_VERSIONS BV1
, PER_BUDGET_ELEMENTS BE
, FND_SESSIONS FND
WHERE HR1.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE'
AND HR1.LOOKUP_CODE (+) = B.UNIT
AND FND.EFFECTIVE_DATE BETWEEN NVL (HR1.START_DATE_ACTIVE
, FND.EFFECTIVE_DATE)
AND NVL (HR1.END_DATE_ACTIVE
, FND.EFFECTIVE_DATE)
AND HR1.ENABLED_FLAG = 'Y'
AND BV1.BUDGET_VERSION_ID = BE.BUDGET_VERSION_ID
AND BV1.BUDGET_ID = B.BUDGET_ID
AND B.BUDGET_TYPE_CODE = 'HR_BUDGET'
AND FND.SESSION_ID = USERENV('SESSIONID')

Columns