48: -- Start
49:
50: CURSOR cust_acct_csr (p_contract_id IN NUMBER) IS
51: SELECT cust_acct_id
52: FROM okc_k_headers_b
53: WHERE id = p_contract_id;
54:
55: CURSOR bill_to_csr (p_contract_id IN NUMBER) IS
56: SELECT bill_to_site_use_id
53: WHERE id = p_contract_id;
54:
55: CURSOR bill_to_csr (p_contract_id IN NUMBER) IS
56: SELECT bill_to_site_use_id
57: FROM okc_k_headers_b
58: WHERE id = p_contract_id;
59:
60:
61: -- Code segment for Customer Account/bill to address