DBA Data[Home] [Help]

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: