VIEW: APPS.PER_POSITIONS_LOV_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'