APPS.OKL_AM_INVOICES_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 185: FROM hz_customer_profiles c

181: CURSOR l_std_terms_csr (
182: cp_cust_id IN NUMBER,
183: cp_site_use_id IN NUMBER) IS
184: SELECT c.standard_terms standard_terms
185: FROM hz_customer_profiles c
186: WHERE c.cust_account_id = cp_cust_id
187: AND c.site_use_id = cp_site_use_id
188: UNION
189: SELECT c1.standard_terms standard_terms

Line 190: FROM hz_customer_profiles c1

186: WHERE c.cust_account_id = cp_cust_id
187: AND c.site_use_id = cp_site_use_id
188: UNION
189: SELECT c1.standard_terms standard_terms
190: FROM hz_customer_profiles c1
191: WHERE c1.cust_account_id = cp_cust_id
192: AND c1.site_use_id IS NULL
193: AND NOT EXISTS (
194: SELECT '1'

Line 195: FROM hz_customer_profiles c2

191: WHERE c1.cust_account_id = cp_cust_id
192: AND c1.site_use_id IS NULL
193: AND NOT EXISTS (
194: SELECT '1'
195: FROM hz_customer_profiles c2
196: WHERE c2.cust_account_id = cp_cust_id
197: AND c2.site_use_id = cp_site_use_id);
198:
199: l_site_use_rec l_site_use_csr%ROWTYPE;