[Home] [Help]
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
Name |
NAME |
MEANING |
UNIT |
BUDGET_ID |
PERIOD_SET_NAME |
BUSINESS_GROUP_ID |
VERSION_NUMBER |
BUDGET_VERSION_ID |
DATE_FROM |
DATE_TO |
POSITION_ID |
ORGANIZATION_ID |