DBA Data[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