APPS.OZF_REFRESH_SALES_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 41: hz_cust_site_uses_all b

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;
45: EXCEPTION