507: --
508: cursor csr_per_mgr_orgs is
509: select org.organization_id,
510: org_tl.name
511: from hr_all_organization_units org,
512: hr_all_organization_units_tl org_tl
513: where org.organization_id = org_tl.organization_id
514: and exists (select null
515: from hr_organization_information org_info
508: cursor csr_per_mgr_orgs is
509: select org.organization_id,
510: org_tl.name
511: from hr_all_organization_units org,
512: hr_all_organization_units_tl org_tl
513: where org.organization_id = org_tl.organization_id
514: and exists (select null
515: from hr_organization_information org_info
516: where org_info.organization_id = org.organization_id