APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEO_NAME_REFERENCES

Line 740: FROM hz_geo_name_references

736: END IF;
737: -- Bug 4551957
738: BEGIN
739: SELECT 1 into l_count_geo
740: FROM hz_geo_name_references
741: WHERE location_id = p_location_id
742: AND rownum = 1;
743: EXCEPTION WHEN NO_DATA_FOUND THEN
744: l_count_geo := 0;

Line 1547: FROM hz_geo_name_references gnr, hz_geographies geo

1543:
1544: BEGIN
1545: SELECT gnr.geography_id, geo.geography_code, geo.geography_name, geo.geography_use
1546: INTO x_geography_id, x_geography_code, x_geography_name, l_geography_use
1547: FROM hz_geo_name_references gnr, hz_geographies geo
1548: WHERE gnr.location_table_name = x_location_table_name
1549: AND gnr.location_id = p_location_id
1550: AND gnr.geography_type = p_geography_type
1551: AND geo.geography_id = gnr.geography_id;

Line 1831: FROM hz_geo_name_references gnr, hz_geographies g

1827: BEGIN
1828: l_error_flag := 'N';
1829: SELECT gnr.geography_id, gnr.geography_type, g.geography_name
1830: BULK COLLECT INTO l_geography_id, l_geography_type, l_geography_name
1831: FROM hz_geo_name_references gnr, hz_geographies g
1832: WHERE location_table_name = x_loc_tbl
1833: AND location_id = location_id_tbl(i)
1834: AND gnr.geography_id = g.geography_id
1835: ORDER BY gnr.geography_id;