APPS.OKS_AUTH_UTIL_PVT dependencies on HZ_LOCATIONS

Line 673: FROM HZ_LOCATIONS HZ

669: CURSOR l_loc_site_name_csr IS
670: SELECT
671: SUBSTR(replace(arp_addr_label_pkg.format_address
672: (NULL,HZ.ADDRESS1,HZ.ADDRESS2,HZ.ADDRESS3,HZ.ADDRESS4,HZ.CITY,HZ.COUNTY,HZ.STATE,HZ.PROVINCE,HZ.POSTAL_CODE,NULL,HZ.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)
673: FROM HZ_LOCATIONS HZ
674: WHERE HZ.LOCATION_ID=p_install_location_id;
675:
676:
677: CURSOR l_vendor_site_name_csr IS

Line 703: ELSIF(l_install_loc_type='HZ_LOCATIONS') THEN

699: OPEN l_site_name_csr;
700: FETCH l_site_name_csr INTO l_install_site_name;
701: CLOSE l_site_name_csr;
702:
703: ELSIF(l_install_loc_type='HZ_LOCATIONS') THEN
704:
705: OPEN l_loc_site_name_csr;
706: FETCH l_loc_site_name_csr INTO l_install_site_name;
707: CLOSE l_loc_site_name_csr;