APPS.HZ_GEO_UI_UTIL_PUB dependencies on HZ_LOCATIONS

Line 565: from hz_locations loc

561: is
562: select 'Y'
563: from hz_geo_name_reference_log geo
564: where exists ( select 'Y'
565: from hz_locations loc
566: where loc.country = ll_country_code
567: AND geo.location_id = loc.location_id)
568: and location_table_name = 'HZ_LOCATIONS'
569: and rownum = 1; --bug 6870808

Line 568: and location_table_name = 'HZ_LOCATIONS'

564: where exists ( select 'Y'
565: from hz_locations loc
566: where loc.country = ll_country_code
567: AND geo.location_id = loc.location_id)
568: and location_table_name = 'HZ_LOCATIONS'
569: and rownum = 1; --bug 6870808
570: */
571:
572: /* Modified cursor for bug 10144809 (Nishant Singhai) */

Line 575: -- created or modified for a country, and if data exists in HZ_LOCATIONS

571:
572: /* Modified cursor for bug 10144809 (Nishant Singhai) */
573: -- Removed the checking of existance of data in HZ_GEO_NAME_REFERENCE_LOG
574: -- because irrespective of data existing in GNR Log table, if the setup is
575: -- created or modified for a country, and if data exists in HZ_LOCATIONS
576: --- then running of GNR program should be suggested.
577: CURSOR HZ_CUR(ll_country_code IN VARCHAR2)
578: IS
579: SELECT 'Y'

Line 580: FROM HZ_LOCATIONS LOC

576: --- then running of GNR program should be suggested.
577: CURSOR HZ_CUR(ll_country_code IN VARCHAR2)
578: IS
579: SELECT 'Y'
580: FROM HZ_LOCATIONS LOC
581: WHERE LOC.COUNTRY = ll_country_code
582: AND ROWNUM = 1;
583:
584: /* -- commented for bug 10144809

Line 600: -- created or modified for a country, and if data exists in HZ_LOCATIONS

596:
597: /* Modified cursor for bug 10144809 (Nishant Singhai) */
598: -- Removed the checking of existance of data in HZ_GEO_NAME_REFERENCE_LOG
599: -- because irrespective of data existing in GNR Log table, if the setup is
600: -- created or modified for a country, and if data exists in HZ_LOCATIONS
601: --- then running of GNR program should be suggested.
602: CURSOR hr_cur(ll_country_code IN VARCHAR2)
603: IS
604: SELECT 'Y'

Line 621: if(p_loc_table_name = 'HZ_LOCATIONS')

617: close geo_cur;
618: if( l_country_code is not null)
619: then
620: -- check if gnr data exists
621: if(p_loc_table_name = 'HZ_LOCATIONS')
622: then
623: open hz_cur(l_country_code);
624: fetch hz_cur into l_value;
625: close hz_cur;