APPS.ZX_TCM_GEO_JUR_PKG dependencies on HZ_GEO_NAME_REFERENCES

Line 727: FROM hz_geo_name_references

723: END IF;
724: -- Bug 4551957
725: BEGIN
726: SELECT 1 into l_count_geo
727: FROM hz_geo_name_references
728: WHERE location_id = p_location_id
729: AND rownum = 1;
730: EXCEPTION WHEN NO_DATA_FOUND THEN
731: l_count_geo := 0;

Line 1340: FROM hz_geo_name_references gnr, hz_geographies geo

1336:
1337: BEGIN
1338: SELECT gnr.geography_id, geo.geography_code, geo.geography_name, geo.geography_use
1339: INTO x_geography_id, x_geography_code, x_geography_name, l_geography_use
1340: FROM hz_geo_name_references gnr, hz_geographies geo
1341: WHERE gnr.location_table_name = x_location_table_name
1342: AND gnr.location_id = p_location_id
1343: AND gnr.geography_type = p_geography_type
1344: AND geo.geography_id = gnr.geography_id;

Line 1620: FROM hz_geo_name_references gnr, hz_geographies g

1616: BEGIN
1617: l_error_flag := 'N';
1618: SELECT gnr.geography_id, gnr.geography_type, g.geography_name
1619: BULK COLLECT INTO l_geography_id, l_geography_type, l_geography_name
1620: FROM hz_geo_name_references gnr, hz_geographies g
1621: WHERE location_table_name = x_loc_tbl
1622: AND location_id = location_id_tbl(i)
1623: AND gnr.geography_id = g.geography_id
1624: ORDER BY gnr.geography_id;