APPS.OZF_OFFER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 538: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

534:
535: -- bug 3435528 populate cust_account_id to beneficiary_account_id
536: CURSOR c_cust_account_id(p_site_use_id NUMBER, p_site_use_code VARCHAR2) IS
537: SELECT a.cust_account_id
538: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
539: WHERE a.cust_acct_site_id = b.cust_acct_site_id
540: AND b.site_use_code = p_site_use_code
541: AND b.site_use_id = p_site_use_id;
542: -- end comment