236: hr_all_organization_units_tl estab_tl,
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,
242: fnd_territories estab_ft,
243: fnd_territories comp_ft
244: where estab.organization_id = p_estab_id
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,
242: fnd_territories estab_ft,
243: fnd_territories comp_ft
244: where estab.organization_id = p_estab_id
245: and estab.business_group_id = p_business_group_id