了解一下 职位设置后，执行“填写员工层次结构” 请求。
请求将会向哪些表 HR.PER_POS_STRUCTURE_ELEMENTS 写入职位结构元素 ？
-- PO>>设置>>人员>>职务
SELECT PJ.BUSINESS_GROUP_ID AS "职务组ID", PJ.JOB_ID, PJ.JOB_DEFINITION_ID,
(SELECT HAOU.NAME FROM HR.HR_ALL_ORGANIZATION_UNITS HAOU
WHERE HAOU.ORGANIZATION_ID = PJ.BUSINESS_GROUP_ID AND ROWNUM=1
) AS "职务组",
PJ.NAME AS "职务-名称",
PJ.DATE_FROM AS "日期-从",
PJ.DATE_TO AS "日期-至"
FROM APPS.PER_JOBS_VL PJ
order by PJ.NAME
/* Formatted on 2023/4/27 9:43:29 (QP5 v5.256.13226.35510) */
-- 此职位报告对象--上层职位 (LOV 的数据源)
SELECT DISTINCT position_id, name
FROM (SELECT pos.position_id, pft.name
FROM per_pos_structure_elements ose,
hr_all_positions_f pos,
hr_all_positions_f_tl pft
WHERE pos.position_id != :pst1_position_id -- 39191 89288
-- AND :ctl_globals_session_date BETWEEN pos.effective_start_date
-- AND pos.effective_end_date
AND ( ose.subordinate_position_id = pos.position_id
OR ose.parent_position_id = pos.position_id)
AND ose.pos_structure_version_id =
:pse1_pos_structure_version_id -- 61
AND pos.business_group_id = :ctl_globals_business_group_id
AND pos.position_id NOT IN ( SELECT ose.subordinate_position_id
FROM per_pos_structure_elements ose
WHERE ose.pos_structure_version_id =
:pse1_pos_structure_version_id
AND ose.business_group_id =
:ctl_globals_business_group_id --0 ： SETUP BUSINESS GROUPS
CONNECT BY PRIOR ose.subordinate_position_id =
ose.parent_position_id
AND ose.pos_structure_version_id =
:pse1_pos_structure_version_id -- 61
AND ose.business_group_id =
:ctl_globals_business_group_id
START WITH ose.parent_position_id =
:pse1_subordinate_position_id --89288
AND ose.pos_structure_version_id =
:pse1_pos_structure_version_id
AND ose.business_group_id =
:ctl_globals_business_group_id)
AND DECODE (
HR_SECURITY.VIEW_ALL,
'Y', 'TRUE',
HR_SECURITY.SHOW_RECORD ('PER_ALL_POSITIONS',
pos.POSITION_ID)) = 'TRUE'
AND DECODE (hr_general.get_xbg_profile,
'Y', pos.business_group_id,
hr_general.get_business_group_id) =
pos.business_group_id
AND pos.position_id = pft.position_id
AND PFT.LANGUAGE = USERENV ('LANG'))
ORDER BY name