View: GHR_POSITIONS_V

Product:	GHR - US Federal Human Resources
Description:	GHR_PA_POSITIONS_V is a view based on PER_POSITIONS to help give alist of values to be selected on PA request form.
Implementation/DBA Data:	APPS.GHR_POSITIONS_V

View Text

SELECT GHR_API.GET_POSITION_TITLE_POS(POS.POSITION_ID
, POS.BUSINESS_GROUP_ID) POS_TITLE
, GHR_API.GET_POSITION_DESC_NO_POS(POS.POSITION_ID
, POS.BUSINESS_GROUP_ID) POS_NUMBER
, GHR_API.GET_POSITION_SEQUENCE_NO_POS(POS.POSITION_ID
, POS.BUSINESS_GROUP_ID) POS_SEQ_NO
, GHR_API.GET_POSITION_AGENCY_CODE_POS(POS.POSITION_ID
, POS.BUSINESS_GROUP_ID) POS_AGENCY_CODE
, POS.POSITION_ID
, POS.NAME
, POS.BUSINESS_GROUP_ID
, POS.DATE_EFFECTIVE
, POS.DATE_END
, POS.JOB_ID
, GHR_API.GET_JOB_OCC_SERIES_JOB(POS.JOB_ID
, POS.BUSINESS_GROUP_ID) JOB_OCC_SERIES
, POS.ORGANIZATION_ID
, POS.LOCATION_ID
, POS.STATUS
FROM PER_POSITIONS POS

Columns