DBA Data[Home] [Help]

APPS.IBE_ATP_PVT dependencies on HZ_PARTY_SITES

Line 47: from hz_party_sites party_site,

43:
44: l_ship_site_use_id NUMBER;
45: Cursor get_site_use_id(l_party_site_id number) is
46: select site_use.site_use_id
47: from hz_party_sites party_site,
48: hz_cust_acct_sites_all acct_site,
49: hz_cust_site_uses_all site_use
50: where party_site.party_site_id = acct_site.party_site_id
51: and acct_site.cust_acct_site_id = site_use.cust_acct_site_id