DBA Data[Home] [Help]

APPS.JL_BR_SPED_PUB dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 441: hz_geography_identifiers geo_ident,

437: CURSOR get_state_code IS
438: SELECT
439: identifier_value state
440: FROM
441: hz_geography_identifiers geo_ident,
442: hz_geo_name_references geo_ref,
443: hz_locations loc
444: WHERE
445: loc.location_id = P_LOCATION_ID

Line 457: hz_geography_identifiers geo_ident,

453: CURSOR get_city_code IS
454: SELECT
455: identifier_value city
456: FROM
457: hz_geography_identifiers geo_ident,
458: hz_geo_name_references geo_ref,
459: hz_locations loc
460: WHERE
461: loc.location_id = P_LOCATION_ID