VIEW: APPS.PER_BUDGET_ELEMENTS_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))