APPS.OZF_REFRESH_SALES_PVT dependencies on HZ_CUST_ACCT_SITES_ALL
Line 40: FROM hz_cust_acct_sites_all a,
36: is
37: l_party_site_id number;
38: begin
39: SELECT max(a.party_site_id) into l_party_site_id 40: FROM hz_cust_acct_sites_all a, 41: hz_cust_site_uses_all b
42: WHERE b.site_use_id = p_id
43: AND b.cust_acct_site_id = a.cust_acct_site_id;
44: return l_party_site_id;