APPS.AST_UWQ_WRAPPER_PKG dependencies on HZ_PARTY_SITES

Line 876: FROM hz_party_sites

872: my_message VARCHAR2(1000);
873:
874: CURSOR c_get_primary_address_id IS
875: SELECT party_site_id
876: FROM hz_party_sites
877: WHERE party_id = p_customer_id
878: AND identifying_address_flag = 'Y'
879: AND status = 'A';
880:

Line 1117: FROM hz_party_sites

1113: WHERE RESOURCE_ID = p_resource_id;
1114:
1115: CURSOR c_get_primary_address_id IS
1116: SELECT party_site_id
1117: FROM hz_party_sites
1118: WHERE party_id = p_customer_id
1119: AND identifying_address_flag = 'Y'
1120: AND status = 'A';
1121: