APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 4358: FROM hz_customer_profiles c

4354: ----------------------------------------------------------------------------
4355: CURSOR l_std_terms_csr (cp_cust_id IN NUMBER,
4356: cp_site_use_id IN NUMBER) IS
4357: SELECT c.standard_terms standard_terms
4358: FROM hz_customer_profiles c
4359: WHERE c.cust_account_id = cp_cust_id
4360: AND c.site_use_id = cp_site_use_id
4361: UNION
4362: SELECT c1.standard_terms standard_terms

Line 4363: FROM hz_customer_profiles c1

4359: WHERE c.cust_account_id = cp_cust_id
4360: AND c.site_use_id = cp_site_use_id
4361: UNION
4362: SELECT c1.standard_terms standard_terms
4363: FROM hz_customer_profiles c1
4364: WHERE c1.cust_account_id = cp_cust_id
4365: AND c1.site_use_id IS NULL
4366: AND NOT EXISTS (
4367: SELECT '1'

Line 4368: FROM hz_customer_profiles c2

4364: WHERE c1.cust_account_id = cp_cust_id
4365: AND c1.site_use_id IS NULL
4366: AND NOT EXISTS (
4367: SELECT '1'
4368: FROM hz_customer_profiles c2
4369: WHERE c2.cust_account_id = cp_cust_id
4370: AND c2.site_use_id = cp_site_use_id);
4371:
4372: l_site_use_rec l_site_use_csr%ROWTYPE;