71:
72: -- Get Customer Bill_To Address
73: CURSOR l_cust_acct_site_csr (cp_chr_id IN NUMBER) IS
74: SELECT khr.bill_to_site_use_id
75: FROM okc_k_headers_b khr
76: WHERE khr.id = cp_chr_id;
77:
78: -- Get Contract Salesperson
79: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
77:
78: -- Get Contract Salesperson
79: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
80: SELECT con.object1_id1
81: FROM okc_k_headers_b CHR,
82: okc_contact_sources cso,
83: okc_k_party_roles_b kpr,
84: okc_contacts con
85: WHERE CHR.id = cp_chr_id