APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_CONTACTS_V

Line 28585: FROM okc_contacts_v sales,

28581: l_customer_number okl_header_interface.customer_number%TYPE;
28582:
28583: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28584: SELECT sales.object1_id1
28585: FROM okc_contacts_v sales,
28586: okc_k_party_roles_v party
28587: WHERE sales.cpl_id = party.id
28588: AND party.rle_code = 'LESSOR'
28589: AND party.chr_id = p_chr_id

Line 28593: l_salesperson_id okc_contacts_v.object1_id1%TYPE;

28589: AND party.chr_id = p_chr_id
28590: AND party.dnz_chr_id = p_chr_id -- Bug# 3862650
28591: AND sales.role = 'Salesperson';
28592:
28593: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28594: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28595:
28596: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28597: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS