APPS.ASO_OPP_QTE_PUB dependencies on HZ_PARTY_SITES

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

Line 277: FROM hz_party_sites

273: AND hpsu.status='A';
274:
275: CURSOR c_identifying_address(p_party_id IN Number) IS
276: SELECT party_site_id
277: FROM hz_party_sites
278: WHERE party_id= p_party_id
279: AND status='A'
280: AND identifying_address_flag='Y';
281:

Line 1816: SELECT location_id from hz_party_sites

1812: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1813: )
1814: IS
1815: CURSOR c_location(p_party_site_id IN Number) IS
1816: SELECT location_id from hz_party_sites
1817: WHERE party_site_id = p_party_site_id ;
1818:
1819: CURSOR c_loc_assign(p_location_id IN Number) IS
1820: SELECT loc_id from hz_loc_assignments