Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT BRPL.BUDGET_REVISION_ID
, BRP.BUDGET_REVISION_POS_LINE_ID
, BRP.POSITION_ID
, PP.NAME
, PP.HR_EMPLOYEE_ID
, PE.EMPLOYEE_NUMBER
, PE.FULL_NAME
, BRP.BUDGET_GROUP_ID
, BRP.EFFECTIVE_START_DATE
, BRP.EFFECTIVE_END_DATE
, BRP.REVISION_TYPE
, BRP.REVISION_VALUE_TYPE
, BRP.REVISION_VALUE
, BRP.REVISION_VALUE
, BRP.REVISION_VALUE
, BRPL.FREEZE_FLAG
, BRPL.VIEW_LINE_FLAG
, BRP.LAST_UPDATE_DATE
, BRP.LAST_UPDATED_BY
, BRP.LAST_UPDATE_LOGIN
, BRP.CREATION_DATE
, BRP.CREATED_BY
FROM PSB_BUDGET_REVISION_POSITIONS BRP
, PSB_BUDGET_REVISION_POS_LINES BRPL
, PSB_EMPLOYEES PE
, PSB_POSITIONS PP
, PSB_POSITION_ASSIGNMENTS PPE
WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRPL.BUDGET_REVISION_POS_LINE_ID
AND BRP.POSITION_ID = PP.POSITION_ID
AND PP.POSITION_ID = PPE.POSITION_ID(+)
AND PPE.ASSIGNMENT_TYPE (+) = 'EMPLOYEE'
AND PPE.EMPLOYEE_ID = PE.EMPLOYEE_ID(+)