DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on STANDARD

Line 4357: SELECT c.standard_terms standard_terms

4353: --get payment term from customer profiles
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

Line 4362: SELECT c1.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
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 (