VIEW: APPS.GHR_POSITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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