DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on HZ_PARTY_SITE_USES

Line 767: hz_party_site_uses hpu

763: -- Cursor to derive primary bill to site id
764: Cursor c_bill_to_site(p_party_id number) is
765: Select hpu.party_site_use_id
766: from hz_party_sites hps,
767: hz_party_site_uses hpu
768: where
769: hps.party_id = p_party_id
770: and hps.party_site_id = hpu.party_site_id
771: and hpu.site_use_type = 'BILL_TO'

Line 778: hz_party_site_uses hpu

774: -- Cursor to derive primary ship to site id
775: Cursor c_ship_to_site(p_party_id number) is
776: Select hpu.party_site_use_id
777: from hz_party_sites hps,
778: hz_party_site_uses hpu
779: where
780: hps.party_id = p_party_id
781: and hps.party_site_id = hpu.party_site_id
782: and hpu.site_use_type = 'SHIP_TO'