DBA Data[Home] [Help]

APPS.HZ_GEO_GET_PUB dependencies on HZ_RELATIONSHIPS

Line 33: FROM hz_relationships

29:
30:
31: CURSOR c_get_zones(c_object_type IN VARCHAR2, c_geography_id IN NUMBER) IS
32: SELECT subject_id
33: FROM hz_relationships
34: WHERE subject_type = p_zone_type
35: AND subject_table_name = 'HZ_GEOGRAPHIES'
36: AND object_type = c_object_type
37: AND object_id = c_geography_id