APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_CONTACTS_V

Line 28288: FROM okc_contacts_v sales,

28284: l_customer_number okl_header_interface.customer_number%TYPE;
28285:
28286: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28287: SELECT sales.object1_id1
28288: FROM okc_contacts_v sales,
28289: okc_k_party_roles_v party
28290: WHERE sales.cpl_id = party.id
28291: AND party.rle_code = 'LESSOR'
28292: AND party.chr_id = p_chr_id

Line 28296: l_salesperson_id okc_contacts_v.object1_id1%TYPE;

28292: AND party.chr_id = p_chr_id
28293: AND party.dnz_chr_id = p_chr_id -- Bug# 3862650
28294: AND sales.role = 'Salesperson';
28295:
28296: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28297: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28298:
28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS