DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on HZ_PARTY_SITE_USES

Line 244: hz_party_site_uses hpu

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
248: and hpu.site_use_type = 'BILL_TO'

Line 255: hz_party_site_uses hpu

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
259: and hpu.site_use_type = 'SHIP_TO'