APPS.OZF_OFFER_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 629: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b

625:
626: -- bug 3435528 populate cust_account_id to beneficiary_account_id
627: CURSOR c_cust_account_id(p_site_use_id NUMBER, p_site_use_code VARCHAR2) IS
628: SELECT a.cust_account_id
629: FROM hz_cust_acct_sites_all a, hz_cust_site_uses_all b
630: WHERE a.cust_acct_site_id = b.cust_acct_site_id
631: AND b.site_use_code = p_site_use_code
632: AND b.site_use_id = p_site_use_id;
633: -- end comment