APPS.OKL_ARINTF_PVT dependencies on OKC_CONTACTS

Line 2233: FROM okc_k_headers_b hdr, okc_contacts contact

2229:
2230: --added new cursor to fetch the sales rep for the contract.
2231: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
2232: SELECT contact.object1_id1
2233: FROM okc_k_headers_b hdr, okc_contacts contact
2234: WHERE contact.dnz_chr_id = hdr.id
2235: AND hdr.contract_number = p_contract_number
2236: AND contact.cro_code = 'SALESPERSON';
2237:

Line 2239: l_sales_person okc_contacts_v.object1_id1%TYPE;

2235: AND hdr.contract_number = p_contract_number
2236: AND contact.cro_code = 'SALESPERSON';
2237:
2238: l_prev_contract_num okc_k_headers_b.contract_number%TYPE;
2239: l_sales_person okc_contacts_v.object1_id1%TYPE;
2240: --vthiruva - Bug 4222231..end
2241:
2242: CURSOR sales_type_credit_csr IS
2243: SELECT sales_credit_type_id