DBA Data[Home] [Help]

APPS.HZ_GEO_UI_UTIL_PUB dependencies on HR_LOCATIONS_ALL

Line 575: from hr_locations_all loc

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)
578: and location_table_name = 'HR_LOCATIONS_ALL'
579: and rownum = 1; --bug 6870808

Line 578: and location_table_name = 'HR_LOCATIONS_ALL'

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)
578: and location_table_name = 'HR_LOCATIONS_ALL'
579: and rownum = 1; --bug 6870808
580:
581: l_return VARCHAR2(10);
582: l_value varchar(1);