View: PER_BUDGET_ELEMENTS_V

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

View Text

SELECT BEL.ROWID ROW_ID
, BEL.BUDGET_ELEMENT_ID
, BEL.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BEL.GRADE_ID
, BEL.JOB_ID
, BEL.POSITION_ID
, BEL.ORGANIZATION_ID
, BEL.BUDGET_VERSION_ID
, BEL.REQUEST_ID
, BEL.PROGRAM_APPLICATION_ID
, BEL.PROGRAM_ID
, BEL.PROGRAM_UPDATE_DATE
, BEL.LAST_UPDATE_DATE
, BEL.LAST_UPDATED_BY
, BEL.LAST_UPDATE_LOGIN
, BEL.CREATED_BY
, BEL.CREATION_DATE
, ORGTL.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, JOB.DATE_FROM JOB_START_DATE
, JOB.DATE_TO JOB_END_DATE
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BEL.POSITION_ID) POSITION_NAME
, POS.DATE_EFFECTIVE POS_START_DATE
, HR_GENERAL.GET_POSITION_DATE_END(BEL.POSITION_ID) POS_END_DATE
, GDT.NAME GRADE_NAME
, GR.DATE_FROM GRADE_START_DATE
, GR.DATE_TO GRADE_END_DATE
FROM PER_BUDGET_ELEMENTS BEL
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PER_JOBS JOB
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS POS
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES GR
, PER_GRADES_TL GDT
WHERE BEL.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND BEL.JOB_ID = JOB.JOB_ID(+)
AND BEL.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND BEL.POSITION_ID = POS.POSITION_ID(+)
AND BEL.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND BEL.GRADE_ID = GR.GRADE_ID(+)
AND BEL.GRADE_ID = GDT.GRADE_ID(+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID(+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns