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: