370:
371: --
372: cursor c_organization is
373: select 1
374: from hr_all_organization_units
375: where organization_id = p_organization_id
376: and business_group_id = p_business_group_id;
377:
378: --
981: SELECT org.name,
982: org.organization_id,
983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id
982: org.organization_id,
983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id
990: AND org.language = USERENV('LANG')