APPS.WSH_OTM_RIQ_XML dependencies on HR_LOCATIONS_ALL
Line 1794: FROM HR_LOCATIONS_ALL hr,FND_TERRITORIES ft
1790:
1791: CURSOR c_get_org_loc_info(p_location_id IN NUMBER)
1792: IS
1793: SELECT hr.postal_code, hr.town_or_city,hr.region_2,ft.iso_territory_code 1794: FROM HR_LOCATIONS_ALL hr,FND_TERRITORIES ft 1795: WHERE
1796: hr.location_id=p_location_id
1797: AND hr.country=ft.territory_code;
1798: