View: PSB_WS_ELEMENT_LINE_NAMES_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_WS_ELEMENT_LINE_NAMES_V

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