[Home] [Help]
46:
47: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
48: SELECT cs.cust_acct_site_id
49: -- , cp.standard_terms payment_term_id
50: FROM okc_k_headers_v khr
51: , okx_cust_site_uses_v cs
52: , hz_customer_profiles cp
53: WHERE khr.id = p_khr_id
54: AND khr.bill_to_site_use_id = cs.id1