DBA Data[Home] [Help]

VIEW: APPS.HR_POSITIONS_LOV_V

Source

View Text - Preformatted

SELECT P.NAME ,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 ,P.DATE_END ,P.STATUS ,P.POSITION_DEFINITION_ID FROM HR_POSITIONS P
View Text - HTML Formatted

SELECT P.NAME
, 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
, P.DATE_END
, P.STATUS
, P.POSITION_DEFINITION_ID
FROM HR_POSITIONS P