DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on OKC_K_HEADERS_B

Line 75: FROM okc_k_headers_b khr

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

Line 81: FROM okc_k_headers_b CHR,

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