VIEW: APPS.HRBV_POSITION

Source

View Text - Preformatted

SELECT posT.name position_name ,'_KF:PER:POS:pdef' ,pos.date_effective date_from ,pos.date_end date_to ,hr_bis.bis_decode_lookup('POSITION_STATUS', pos.status) position_status ,pos.working_hours working_hours_amount ,hr_bis.bis_decode_lookup('FREQUENCY',pos.frequency) working_hours_frequency ,pos.probation_period probation_period ,hr_bis.bis_decode_lookup('QUALIFYING_UNITS',pos.probation_period_units) probation_units ,hr_bis.bis_decode_lookup('YES_NO',pos.replacement_required_flag) replacement_required_flag ,pos.time_normal_start normal_start_time ,pos.time_normal_finish normal_end_time ,pos.comments comments ,'_DF:PER:PER_POSITIONS:pos' ,pos.status position_status_code ,pos.frequency working_hours_frequency_code ,pos.probation_period_units probation_period_units_code ,pos.replacement_required_flag replacement_required_flag_code ,hr_api.return_legislation_code(pos.business_group_id) legislation_code ,pos.business_group_id business_group_id ,pos.job_id job_id ,pos.location_id location_id ,pos.organization_id organization_id ,pos.position_id position_id ,pos.position_definition_id position_definition_id ,pos.relief_position_id relief_position_id ,pos.successor_position_id successor_position_id ,pos.last_update_date last_update_date ,pos.last_updated_by last_updated_by ,pos.last_update_login last_update_login ,pos.created_by created_by ,pos.creation_date creation_date , CASE WHEN (pos.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pos.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_position_definitions pdef ,hr_all_positions_f_tl posT ,per_positions pos WHERE pdef.position_definition_id = pos.position_definition_id AND pdef.enabled_flag = 'Y' AND pos.position_id = posT.position_id AND posT.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT POST.NAME POSITION_NAME
, '_KF:PER:POS:PDEF'
, POS.DATE_EFFECTIVE DATE_FROM
, POS.DATE_END DATE_TO
, HR_BIS.BIS_DECODE_LOOKUP('POSITION_STATUS'
, POS.STATUS) POSITION_STATUS
, POS.WORKING_HOURS WORKING_HOURS_AMOUNT
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, POS.FREQUENCY) WORKING_HOURS_FREQUENCY
, POS.PROBATION_PERIOD PROBATION_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, POS.PROBATION_PERIOD_UNITS) PROBATION_UNITS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, POS.REPLACEMENT_REQUIRED_FLAG) REPLACEMENT_REQUIRED_FLAG
, POS.TIME_NORMAL_START NORMAL_START_TIME
, POS.TIME_NORMAL_FINISH NORMAL_END_TIME
, POS.COMMENTS COMMENTS
, '_DF:PER:PER_POSITIONS:POS'
, POS.STATUS POSITION_STATUS_CODE
, POS.FREQUENCY WORKING_HOURS_FREQUENCY_CODE
, POS.PROBATION_PERIOD_UNITS PROBATION_PERIOD_UNITS_CODE
, POS.REPLACEMENT_REQUIRED_FLAG REPLACEMENT_REQUIRED_FLAG_CODE
, HR_API.RETURN_LEGISLATION_CODE(POS.BUSINESS_GROUP_ID) LEGISLATION_CODE
, POS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.JOB_ID JOB_ID
, POS.LOCATION_ID LOCATION_ID
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.POSITION_ID POSITION_ID
, POS.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
, POS.RELIEF_POSITION_ID RELIEF_POSITION_ID
, POS.SUCCESSOR_POSITION_ID SUCCESSOR_POSITION_ID
, POS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, POS.LAST_UPDATED_BY LAST_UPDATED_BY
, POS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POS.CREATED_BY CREATED_BY
, POS.CREATION_DATE CREATION_DATE
, CASE WHEN (POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_POSITION_DEFINITIONS PDEF
, HR_ALL_POSITIONS_F_TL POST
, PER_POSITIONS POS
WHERE PDEF.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID
AND PDEF.ENABLED_FLAG = 'Y'
AND POS.POSITION_ID = POST.POSITION_ID
AND POST.LANGUAGE = USERENV('LANG') WITH READ ONLY