DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKC_K_HEADERS_V

Line 343: FROM okc_k_headers_v a,

339: CURSOR cur_address_billto(p_contract_id IN VARCHAR2) IS
340: SELECT a.cust_acct_id cust_account_id,
341: b.cust_acct_site_id,
342: c.standard_terms payment_term_id
343: FROM okc_k_headers_v a,
344: okx_cust_site_uses_v b,
345: hz_customer_profiles c
346: WHERE a.id = p_contract_id
347: AND a.bill_to_site_use_id = b.id1