EBS: 请求“填写员工层次结构”

 

了解一下 职位设置后，执行“填写员工层次结构” 请求。

请求将会向哪些表 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