DBA Data[Home] [Help]

APPS.WSH_OTM_RIQ_XML dependencies on HZ_LOCATIONS

Line 1785: FROM HZ_LOCATIONS hz,FND_TERRITORIES ft

1781: */
1782: CURSOR c_get_cus_loc_info(p_location_id IN NUMBER)
1783: IS
1784: SELECT hz.postal_code, hz.city,hz.state,ft.iso_territory_code
1785: FROM HZ_LOCATIONS hz,FND_TERRITORIES ft
1786: WHERE
1787: hz.location_id=p_location_id
1788: AND hz.country=ft.territory_code;
1789: