DBA Data[Home] [Help]

APPS.HZ_GNR_PUB dependencies on HZ_GEO_NAME_REFERENCE_LOG

Line 158: FROM HZ_GEO_NAME_REFERENCE_LOG

154: l_address_status VARCHAR2(30);
155:
156: CURSOR c_gnr IS
157: SELECT MAP_STATUS
158: FROM HZ_GEO_NAME_REFERENCE_LOG
159: WHERE LOCATION_TABLE_NAME = p_location_table_name
160: AND LOCATION_ID = p_location_id
161: AND USAGE_CODE = p_usage_code;
162: BEGIN