2165: mgr.person_id,
2166: mgr.full_name,
2167: org.last_update_date
2168: from hr_all_organization_units org
2169: ,per_org_manager_v mgr,hr_organization_information hrorg
2170: where org.business_group_id = mgr.business_group_id(+)
2171: and org.organization_id = mgr.organization_id(+)
2172: and hrorg.organization_id = org.organization_id
2173: and hrorg.org_information1 = 'HR_ORG'
2210: mgr.person_id,
2211: mgr.full_name,
2212: org.last_update_date
2213: from hr_all_organization_units org
2214: ,per_org_manager_v mgr,hr_organization_information hrorg
2215: where org.business_group_id = mgr.business_group_id(+)
2216: and org.organization_id = mgr.organization_id(+)
2217: and hrorg.organization_id = org.organization_id
2218: and hrorg.org_information1 = 'HR_ORG'