APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on HZ_GEOGRAPHIES

Line 563: v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511

559:
560: v_hr_zone hr_locations_all.region_1%TYPE;
561: v_hr_province hr_locations_all.region_2%TYPE;
562: v_hr_city hr_locations_all.town_or_city%TYPE;
563: v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
564: pc_vendor_id number;
565: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';
566:
567:

Line 735: from hz_geographies

731: ---------------------------------------------------------------
732: --Bug no: 6147511. Added this query to get the city name from geographies table
733: select geography_name
734: into v_hr_city_name
735: from hz_geographies
736: where geography_code= db_reg.city_code
737: and geography_type='CITY';
738: --Bug no: 6147511, Previous condition : IF db_reg.city_code = v_hr_city THEN
739: IF v_hr_city_name = v_hr_city THEN