APPS.ASO_QUOTE_PUB_W dependencies on HZ_PARTY_SITE_USES

Line 12372: FROM hz_party_sites hps, hz_party_site_uses hpsu

12368:
12369: -- Get the primary address
12370: CURSOR c_primary_address(p_party_id NUMBER, p_site_use_type VARCHAR2) IS
12371: SELECT hps.party_site_id
12372: FROM hz_party_sites hps, hz_party_site_uses hpsu
12373: WHERE hps.party_id= p_party_id
12374: AND hps.status='A'
12375: AND hps.party_site_id= hpsu.party_site_id
12376: AND hpsu.site_use_type= p_site_use_type