APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on FND_OBJECTS

Line 160: FROM FND_OBJECTS

156: -- initialize the variables for creating fnd_object_instance_sets
157:
158:
159: SELECT object_id into l_object_id
160: FROM FND_OBJECTS
161: WHERE obj_name='HZ_GEOGRAPHIES';
162:
163: -- Replace the ' in predicate with ''
164: l_predicate := 'GEOGRAPHY_TYPE='||''''||replace(l_geography_type,'''','''''')||'''';

Line 1299: FROM FND_OBJECTS

1295: -- initialize the variables for creating fnd_object_instance_sets
1296:
1297:
1298: SELECT object_id into l_object_id
1299: FROM FND_OBJECTS
1300: WHERE obj_name='HZ_GEOGRAPHIES';
1301:
1302: -- Replace the ' in predicate with ''
1303: l_predicate := 'GEOGRAPHY_TYPE='||''''||replace(p_zone_type_rec.geography_type,'''','''''')||'''';