DBA Data[Home] [Help]

APPS.HZ_GEO_UI_UTIL_PUB dependencies on HZ_GEO_NAME_REFERENCE_LOG

Line 562: from hz_geo_name_reference_log geo

558:
559: cursor hz_cur(ll_country_code in varchar2)
560: is
561: select 'Y'
562: from hz_geo_name_reference_log geo
563: where exists ( select 'Y'
564: from hz_locations loc
565: where loc.country = ll_country_code
566: AND geo.location_id = loc.location_id)

Line 573: from hz_geo_name_reference_log geo

569:
570: cursor hr_cur(ll_country_code in varchar2)
571: is
572: select 'Y'
573: from hz_geo_name_reference_log geo
574: where exists ( select 'Y'
575: from hr_locations_all loc
576: where loc.country = ll_country_code
577: AND geo.location_id = loc.location_id)