APPS.ASO_OPP_QTE_PUB dependencies on HZ_PARTY_SITE_USES

Line 267: FROM hz_party_sites hps, hz_party_site_uses hpsu

263: AND nvl(hcp.status,'A') = 'A';
264:
265: CURSOR c_primary_address(p_party_id IN Number,p_site_use_type VARCHAR2) IS
266: SELECT hps.party_site_id
267: FROM hz_party_sites hps, hz_party_site_uses hpsu
268: WHERE hps.party_id= p_party_id
269: AND hps.status='A'
270: AND hps.party_site_id= hpsu.party_site_id
271: AND hpsu.site_use_type= p_site_use_type