APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_PARTY_SITES

Line 146: FROM Hz_Party_Sites hps,

142: IF l_party_site_id is not null THEN
143: Begin
144: SELECT hpsu.party_site_use_id
145: INTO l_party_site_use_id
146: FROM Hz_Party_Sites hps,
147: Hz_Party_Site_uses hpsu,
148: Hz_Locations hl
149: WHERE hps.party_site_id = l_party_site_id
150: AND hpsu.site_use_type = p_site_use_type

Line 267: from hz_party_sites

263: where party_site_use_id = p_party_site_use_id;
264:
265: CURSOR c_party_id(p_party_site_id in number) IS
266: select party_id
267: from hz_party_sites
268: where party_site_id = p_party_site_id;
269:
270: -- Exception
271: SKIP_RECORD EXCEPTION;