APPS.OZF_TRADE_PROFILE_PVT dependencies on HZ_CUST_SITE_USES

Line 354: from HZ_CUST_SITE_USES

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

Line 749: from HZ_CUST_SITE_USES

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