APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_RELATIONSHIPS

Line 699: hz_relationships hrl

695: /* EXECUTE IMMEDIATE 'SELECT 1 FROM hz_geographies WHERE '||l_geo_element_col||' IS NOT NULL AND country_code='||''''||l_country_code||''''||
696: ' AND rownum <2'; */
697:
698: /* SELECT 1 into l_count from
699: hz_relationships hrl
700: WHERE
701: hrl.relationship_type='MASTER_REF'
702: AND hrl.subject_type= p_parent_geography_type
703: AND hrl.object_type=p_geography_type

Line 1079: delete hz_relationships

1075: and geography_from = l_geography_from
1076: and start_date = l_start_date;
1077:
1078: -- delete master_ref_geogrpahy for postal code range
1079: delete hz_relationships
1080: where subject_id = l_zone_id
1081: and object_id = l_master_ref_geography_id
1082: and subject_table_name = 'HZ_GEOGRAPHIES'
1083: and object_table_name = 'HZ_GEOGRAPHIES'

Line 1087: delete hz_relationships

1083: and object_table_name = 'HZ_GEOGRAPHIES'
1084: and directional_flag = 'F'
1085: and relationship_type = 'TAX' ;
1086:
1087: delete hz_relationships
1088: where subject_id = l_master_ref_geography_id
1089: and object_id = l_zone_id
1090: and subject_table_name = 'HZ_GEOGRAPHIES'
1091: and object_table_name = 'HZ_GEOGRAPHIES'

Line 1112: delete hz_relationships

1108: delete hz_geography_ranges
1109: where master_ref_geography_id = l_geography_id;
1110:
1111: -- delete relationships record both for tax and master_ref relationship_type
1112: delete hz_relationships
1113: where (object_id = l_geography_id
1114: or subject_id = l_geography_id )
1115: and subject_table_name = 'HZ_GEOGRAPHIES'
1116: and object_table_name = 'HZ_GEOGRAPHIES'

Line 1147: DELETE hz_relationships

1143: WHERE geography_type = l_zone_type
1144: AND geography_use = 'TAX');
1145:
1146:
1147: DELETE hz_relationships
1148: WHERE subject_id in (SELECT geography_id
1149: FROM hz_geographies
1150: WHERE geography_type = l_zone_type
1151: AND geography_use = 'TAX')

Line 1157: DELETE hz_relationships

1153: AND subject_table_name = 'HZ_GEOGRAPHIES'
1154: AND relationship_type = 'TAX';
1155:
1156:
1157: DELETE hz_relationships
1158: WHERE object_id in (SELECT geography_id
1159: FROM hz_geographies
1160: WHERE geography_type = l_zone_type
1161: AND geography_use = 'TAX')