Product: | PER - Human Resources |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.HRFV_MANPOWER_BUDGETS |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, BUD.NAME BUDGET_NAME
, HR_BIS.BIS_DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, BUD.UNIT) BUDGET_MEASUREMENT_TYPE
, BUD.UNIT BUDGET_MEASUREMENT_CODE
, CAL.ACTUAL_PERIOD_TYPE BUDGET_FREQUENCY
, BVER.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVER.DATE_FROM BUDGET_VERSION_START_DATE
, BVER.DATE_TO BUDGET_VERSION_END_DATE
, PTP.PERIOD_NAME BUDGET_PERIOD_NAME
, PTP.START_DATE BUDGET_PERIOD_START_DATE
, PTP.END_DATE BUDGET_PERIOD_END_DATE
, BVAL.VALUE PLANNED_VALUE
, HR_DISCOVERER.GET_ACTUAL_BUDGET_VALUES (BUD.UNIT
, BGRT.ORGANIZATION_ID
, ORGT.ORGANIZATION_ID
, JOB.JOB_ID
, POS.POSITION_ID
, GRD.GRADE_ID
, PTP.START_DATE
, PTP.END_DATE
, BVAL.VALUE ) ACTUAL_VALUE
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, '_DF:PER:PER_BUDGETS:BUD'
, '_DF:PER:PER_BUDGET_VERSIONS:BVER'
, BVER.BUDGET_ID BUDGET_ID
, BVAL.TIME_PERIOD_ID BUDGET_PERIOD_ID
, BGRT.ORGANIZATION_ID BUSINESS_GROUP_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
, POS.POSITION_ID POSITION_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, PAY_CALENDARS CAL
, PER_TIME_PERIODS PTP
, PER_BUDGETS BUD
, PER_BUDGET_VERSIONS BVER
, PER_BUDGET_ELEMENTS BELE
, PER_BUDGET_VALUES BVAL
WHERE BVAL.BUDGET_ELEMENT_ID = BELE.BUDGET_ELEMENT_ID
AND BELE.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND BELE.JOB_ID = JOB.JOB_ID (+)
AND BELE.POSITION_ID = POS.POSITION_ID (+)
AND BELE.GRADE_ID = GRD.GRADE_ID (+)
AND BELE.BUDGET_VERSION_ID = BVER.BUDGET_VERSION_ID
AND BVER.BUDGET_ID = BUD.BUDGET_ID
AND BUD.PERIOD_SET_NAME = CAL.PERIOD_SET_NAME
AND BVAL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND BVAL.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND BVAL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BVAL.BUSINESS_GROUP_ID) WITH READ ONLY