摘要:
--职位 positionselect * from PER_POSITIONS_Vwhere (position_id,job_id) in (select position_id,job_id from PO_POSITION_CONTROLS_ALL where org_id = 108)--职位层次结构select * from PER_POSITION_STRUCTURES_V--组织select * from HR_ORGANIZATION_UNITS_V where organization_id = 89select * from hr_operating_units --OU
阅读全文