DBA Data[Home] [Help]

APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKC_K_HEADERS_V

Line 137: FROM okc_k_headers_v a,

133: CURSOR cur_address_billto(p_contract_id IN VARCHAR2) IS
134: SELECT a.cust_acct_id cust_account_id,
135: b.cust_acct_site_id,
136: c.standard_terms payment_term_id
137: FROM okc_k_headers_v a,
138: okx_cust_site_uses_v b,
139: hz_customer_profiles c
140: WHERE a.id = p_contract_id
141: AND a.bill_to_site_use_id = b.id1