[Home] [Help]
View: PSB_WS_ELEMENT_LINE_NAMES_V
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT WEL.ELEMENT_LINE_ID
, WEL.POSITION_LINE_ID
, WEL.BUDGET_YEAR_ID
, WEL.PAY_ELEMENT_ID
, WEL.CURRENCY_CODE
, WEL.ELEMENT_COST
, DECODE(NVL(PE.FOLLOW_SALARY
, 'N')
, 'Y'
, NULL
, 'N'
, WEL. ELEMENT_SET_ID) ELEMENT_SET_ID
, WEL.SERVICE_PACKAGE_ID
, WEL.STAGE_SET_ID
, WEL.START_STAGE_SEQ
, WEL.CURRENT_STAGE_SEQ
, WEL.END_STAGE_SEQ
, PE.NAME
, PE.FOLLOW_SALARY
FROM PSB_WS_ELEMENT_LINES WEL
, PSB_PAY_ELEMENTS PE
WHERE WEL.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
Columns
Name |
ELEMENT_LINE_ID |
POSITION_LINE_ID |
BUDGET_YEAR_ID |
PAY_ELEMENT_ID |
CURRENCY_CODE |
ELEMENT_COST |
ELEMENT_SET_ID |
SERVICE_PACKAGE_ID |
STAGE_SET_ID |
START_STAGE_SEQ |
CURRENT_STAGE_SEQ |
END_STAGE_SEQ |
PAY_ELEMENT_NAME |
FOLLOW_SALARY |