APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 4360: FROM hz_customer_profiles c

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

Line 4365: FROM hz_customer_profiles c1

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

Line 4370: FROM hz_customer_profiles c2

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