DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on HZ_PARTY_SITES

Line 243: from hz_party_sites hps,

239:
240: -- Cursor to derive primary bill to site id
241: Cursor c_bill_to_site(p_party_id number) is
242: Select hpu.party_site_use_id
243: from hz_party_sites hps,
244: hz_party_site_uses hpu
245: where
246: hps.party_id = p_party_id
247: and hps.party_site_id = hpu.party_site_id

Line 254: from hz_party_sites hps,

250:
251: -- Cursor to derive primary ship to site id
252: Cursor c_ship_to_site(p_party_id number) is
253: Select hpu.party_site_use_id
254: from hz_party_sites hps,
255: hz_party_site_uses hpu
256: where
257: hps.party_id = p_party_id
258: and hps.party_site_id = hpu.party_site_id