DBA Data[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on HZ_PARTY_SITES

Line 1842: from hz_party_sites hps,

1838: if p_sr_rec.sr_bill_to_site_use_id is null then
1839: -- get the primary bill to site and ship to site.
1840: Select hpu.party_site_use_id
1841: into l_service_request_rec.bill_to_site_use_id
1842: from hz_party_sites hps,
1843: hz_party_site_uses hpu
1844: where
1845: hps.party_id = p_sr_rec.sr_party_id
1846: and hps.party_site_id = hpu.party_site_id

Line 1858: from hz_party_sites hps,

1854: if p_sr_rec.sr_ship_to_site_use_id is null then
1855: -- get the primary ship to site.
1856: Select hpu.party_site_use_id
1857: into l_service_request_rec.ship_to_site_use_id
1858: from hz_party_sites hps,
1859: hz_party_site_uses hpu
1860: where
1861: hps.party_id = p_sr_rec.sr_party_id
1862: and hps.party_site_id = hpu.party_site_id