APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_ADDRESS_USAGE_DTLS

Line 600: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

596: WHERE map_id = p_map_id;
597:
598: CURSOR c_address_usage_dtls(c_geography_type varchar2) IS
599: SELECT dtl.usage_id
600: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
601: WHERE usg.map_id = p_map_id
602: AND dtl.geography_type = c_geography_type
603: AND dtl.usage_id = usg.usage_id;
604:

Line 804: FROM hz_address_usage_dtls

800: LOOP
801:
802: SELECT count(*)
803: INTO l_count
804: FROM hz_address_usage_dtls
805: WHERE usage_id = i.usage_id;
806:
807: -- If count is > 0 there is usage exists and we need to delete the usage records.
808: -- Else, there is no need to call the delete usage API

Line 1227: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl

1223: END IF;
1224:
1225: SELECT count(*)
1226: INTO l_count
1227: FROM Hz_address_usages usg, Hz_address_usage_dtls dtl
1228: WHERE usg.map_id = p_map_id
1229: AND usg.status_flag = 'A'
1230: AND dtl.usage_id = usg.usage_id;
1231: