APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_CONTACTS

Line 766: FROM okc_k_headers_b hdr, okc_contacts contact

762:
763: --cursor to fetch the sales rep for the contract.
764: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
765: SELECT contact.object1_id1
766: FROM okc_k_headers_b hdr, okc_contacts contact
767: WHERE contact.dnz_chr_id = hdr.id
768: AND hdr.contract_number = p_contract_number
769: AND contact.cro_code = 'SALESPERSON';
770:

Line 773: l_sales_person okc_contacts_v.object1_id1%TYPE;

769: AND contact.cro_code = 'SALESPERSON';
770:
771: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
772: l_salesrep_name ra_salesreps.NAME%TYPE;
773: l_sales_person okc_contacts_v.object1_id1%TYPE;
774: --stmathew - Bug 4372869/4222231..end
775: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
776: l_is_top_line number;
777: is_top_line_flag boolean;