View: PSB_SELECT_POSITIONS_V

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

View Text

SELECT POS.POSITION_ID
, POS.NAME
, POS.ORGANIZATION_ID
, POS.POSITION_DEFINITION_ID
, NVL(POS.NEW_POSITION_FLAG
, 'N')
, POS.NAME
, PSB_POSITIONS_PVT.GET_JOB_NAME(POS.DATA_EXTRACT_ID
, NULL
, POS.POSITION_ID) JOB_NAME
, PSB_POSITIONS_PVT.GET_EMPLOYEE_ID(POS.DATA_EXTRACT_ID
, NULL
, POS.POSITION_ID) EMPLOYEE_ID
, PSB_POSITIONS_PVT.GET_EMPLOYEE_NUMBER(POS.DATA_EXTRACT_ID
, NULL
, POS.POSITION_ID) EMPLOYEE_NUMBER
, PSB_POSITIONS_PVT.GET_EMPLOYEE_NAME(POS.DATA_EXTRACT_ID
, NULL
, POS.POSITION_ID) EMPLOYEE_NAME
, POS.DATA_EXTRACT_ID
FROM PSB_POSITIONS POS

Columns