APPS.OZF_TRADE_PROFILE_PVT dependencies on HZ_CUST_SITE_USES

Line 356: from HZ_CUST_SITE_USES

352: L_API_NAME CONSTANT VARCHAR2(30) := 'Populate_Defaults';
353:
354: CURSOR c_cust_acct_site_id (a_id IN NUMBER) IS
355: SELECT cust_acct_site_id
356: from HZ_CUST_SITE_USES
357: WHERE site_use_id = a_id;
358:
359: CURSOR vendor_site_code_csr (a_id IN NUMBER) IS
360: SELECT vendor_site_code

Line 751: from HZ_CUST_SITE_USES

747: WHERE trade_profile_id = v_trade_profile_id;
748:
749: CURSOR c_cust_acct_site_id (a_id IN NUMBER) IS
750: SELECT cust_acct_site_id
751: from HZ_CUST_SITE_USES
752: WHERE site_use_id = a_id;
753:
754: --l_ref_trade_profile_rec c_get_Trade_Profile%ROWTYPE;
755: l_ref_trade_profile_rec c_trade%ROWTYPE;