[Home] [Help]
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
Name |
POS_TITLE |
POS_NUMBER |
POS_SEQ_NO |
POS_AGENCY_CODE |
POSITION_ID |
NAME |
BUSINESS_GROUP_ID |
DATE_EFFECTIVE |
DATE_END |
JOB_ID |
JOB_OCC_SERIES |
ORGANIZATION_ID |
LOCATION_ID |
STATUS |