[Home] [Help]
APPS.JL_BR_SPED_PUB dependencies on HZ_GEOGRAPHY_IDENTIFIERS
Line 435: hz_geography_identifiers geo_ident,
431: CURSOR get_state_code IS
432: SELECT
433: identifier_value state
434: FROM
435: hz_geography_identifiers geo_ident,
436: hz_geo_name_references geo_ref,
437: hz_locations loc
438: WHERE
439: loc.location_id = P_LOCATION_ID
Line 451: hz_geography_identifiers geo_ident,
447: CURSOR get_city_code IS
448: SELECT
449: identifier_value city
450: FROM
451: hz_geography_identifiers geo_ident,
452: hz_geo_name_references geo_ref,
453: hz_locations loc
454: WHERE
455: loc.location_id = P_LOCATION_ID