SELECT distinct<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0hph.position_hierarchy_name hierarquia<\/p>\n
\u00a0 \u00a0 \u00a0 ,hph.parent_position_id pai<\/p>\n
\u00a0 \u00a0 \u00a0 ,hph.child_position_id filho<\/p>\n
\u00a0 \u00a0 \u00a0 ,hph.position_hierarchy_level nivel<\/p>\n
\u00a0 \u00a0 \u00a0 ,hph.child_position_name aprovadores<\/p>\n
\u00a0 \u00a0 \u00a0 ,pps.attribute2 de<\/p>\n
\u00a0 \u00a0 \u00a0 ,pps.attribute3 ate<\/p>\n
\u00a0 \u00a0 \u00a0 ,hr_general.decode_position_latest_name(hph.parent_position_id)<\/p>\n
\u00a0 FROM per_position_structures pps<\/p>\n
\u00a0 \u00a0 \u00a0 ,per_pos_structure_elements ppe<\/p>\n
\u00a0 \u00a0 \u00a0 ,hrfv_position_hierarchies hph<\/p>\n
\u00a0 \u00a0 \u00a0 ,po_employee_hierarchies_all peh<\/p>\n
\u00a0 \u00a0 \u00a0 ,(<\/p>\n
\u00a0 \u00a0 \u00a0 SELECT pap.position_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ,ppf.business_group_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ,ppf.full_name<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ,pap.position_definition_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 FROM per_all_people_f \u00a0 \u00a0 \u00a0ppf<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ,per_all_assignments_f paa<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ,per_all_positions \u00a0 \u00a0 pap<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0WHERE ppf.person_id = paa.person_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0AND ppf.business_group_id = paa.business_group_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0AND paa.position_id = pap.position_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0AND pap.business_group_id = paa.business_group_id<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0) sub_a<\/p>\n
\u00a0WHERE pps.position_structure_id = ppe.pos_structure_version_id<\/p>\n
\u00a0 \u00a0AND pps.business_group_id = ppe.business_group_id<\/p>\n
\u00a0 \u00a0AND ppe.pos_structure_version_id = hph.position_hierarchy_id<\/p>\n
\u00a0 \u00a0AND ppe.business_group_id = hph.business_group_id<\/p>\n
\u00a0 \u00a0AND ppe.business_group_id = pps.business_group_id<\/p>\n
\u00a0 \u00a0AND ppe.pos_structure_version_id = pps.position_structure_id<\/p>\n
\u00a0 \u00a0–AND hph.position_hierarchy_name = ’00-11-050-> 10000_< 300000′<\/p>\n
\u00a0 \u00a0AND peh.business_group_id = ppe.business_group_id<\/p>\n
\u00a0 \u00a0AND peh.position_structure_id = ppe.pos_structure_version_id<\/p>\n
\u00a0 \u00a0AND peh.business_group_id = hph.business_group_id<\/p>\n
\u00a0 \u00a0AND peh.position_structure_id = hph.position_hierarchy_id<\/p>\n
\u00a0 \u00a0AND ppe.parent_position_id = sub_a.position_id<\/p>\n
\u00a0 \u00a0AND ppe.business_group_id = sub_a.business_group_id<\/p>\n
\u00a0 \u00a0AND hph.business_group_id = sub_a.business_group_id<\/p>\n
\u00a0 \u00a0AND peh.employee_id = sub_a.position_id<\/p>\n
\u00a0 \u00a0AND peh.superior_id = sub_a.position_id<\/p>\n
\u00a0<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT distinct \u00a0 \u00a0 \u00a0 \u00a0hph.position_hierarchy_name hierarquia \u00a0 \u00a0 \u00a0 ,hph.parent_position_id pai \u00a0 \u00a0 \u00a0 ,hph.child_position_id filho \u00a0 \u00a0 \u00a0 ,hph.position_hierarchy_level nivel \u00a0 \u00a0 \u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,138],"tags":[],"class_list":["post-17878","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17878"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17878\/revisions"}],"predecessor-version":[{"id":17879,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17878\/revisions\/17879"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}