APPS.OKL_ARINTF_PVT dependencies on OKC_CONTACTS

Line 1267: FROM okc_k_headers_b hdr, okc_contacts contact

1263:
1264: --added new cursor to fetch the sales rep for the contract.
1265: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
1266: SELECT contact.object1_id1
1267: FROM okc_k_headers_b hdr, okc_contacts contact
1268: WHERE contact.dnz_chr_id = hdr.id
1269: AND hdr.contract_number = p_contract_number
1270: AND contact.cro_code = 'SALESPERSON';
1271:

Line 1273: l_sales_person okc_contacts_v.object1_id1%TYPE;

1269: AND hdr.contract_number = p_contract_number
1270: AND contact.cro_code = 'SALESPERSON';
1271:
1272: l_prev_contract_num okc_k_headers_b.contract_number%TYPE;
1273: l_sales_person okc_contacts_v.object1_id1%TYPE;
1274: --vthiruva - Bug 4222231..end
1275:
1276: CURSOR sales_type_credit_csr IS
1277: SELECT sales_credit_type_id