eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_POSITIONS_LOV_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_POSITIONS_LOV_V

View Text

SELECT HR_GENERAL.DECODE_POSITION_LATEST_NAME(P.POSITION_ID)
, P.POSITION_ID
, P.LOCATION_ID
, P.WORKING_HOURS
, P.FREQUENCY
, P.TIME_NORMAL_FINISH
, P.TIME_NORMAL_START
, P.PROBATION_PERIOD
, P.PROBATION_PERIOD_UNIT_CD
, P.BUSINESS_GROUP_ID
, P.ORGANIZATION_ID
, P.JOB_ID
, P.DATE_EFFECTIVE
, HR_GENERAL.GET_POSITION_DATE_END (P.POSITION_ID)
, P.STATUS
, HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID (P.POSITION_ID)
FROM HR_POSITIONS P
WHERE HR_PSF_SHD.GET_AVAILABILITY_STATUS(P.AVAILABILITY_STATUS_ID
, P.BUSINESS_GROUP_ID)='ACTIVE'

Columns

Name
POSITION
POSITION_ID
LOCATION_ID
WORKING_HOURS
FREQUENCY
TIME_NORMAL_FINISH
TIME_NORMAL_START
PROBATION_PERIOD
PROBATION_PERIOD_UNITS
BUSINESS_GROUP_ID
ORGANIZATION_ID
JOB_ID
DATE_EFFECTIVE
DATE_END
STATUS
POSITION_DEFINITION_ID