APPS.HZ_GEO_UI_UTIL_PUB dependencies on HR_LOCATIONS_ALL

Line 590: from hr_locations_all loc

586: is
587: select 'Y'
588: from hz_geo_name_reference_log geo
589: where exists ( select 'Y'
590: from hr_locations_all loc
591: where loc.country = ll_country_code
592: AND geo.location_id = loc.location_id)
593: and location_table_name = 'HR_LOCATIONS_ALL'
594: and rownum = 1; --bug 6870808

Line 593: and location_table_name = 'HR_LOCATIONS_ALL'

589: where exists ( select 'Y'
590: from hr_locations_all loc
591: where loc.country = ll_country_code
592: AND geo.location_id = loc.location_id)
593: and location_table_name = 'HR_LOCATIONS_ALL'
594: and rownum = 1; --bug 6870808
595: */
596:
597: /* Modified cursor for bug 10144809 (Nishant Singhai) */

Line 605: FROM HR_LOCATIONS_ALL LOC

601: --- then running of GNR program should be suggested.
602: CURSOR hr_cur(ll_country_code IN VARCHAR2)
603: IS
604: SELECT 'Y'
605: FROM HR_LOCATIONS_ALL LOC
606: WHERE LOC.COUNTRY = ll_country_code
607: AND ROWNUM = 1;
608:
609: l_return VARCHAR2(10);