VIEW: APPS.PSB_WS_ELEMENT_LINE_NAMES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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