APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_CONTACTS

Line 524: FROM okc_k_headers_b hdr, okc_contacts contact

520:
521: --cursor to fetch the sales rep for the contract.
522: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
523: SELECT contact.object1_id1
524: FROM okc_k_headers_b hdr, okc_contacts contact
525: WHERE contact.dnz_chr_id = hdr.id
526: AND hdr.contract_number = p_contract_number
527: AND contact.cro_code = 'SALESPERSON';
528:

Line 531: l_sales_person okc_contacts_v.object1_id1%TYPE;

527: AND contact.cro_code = 'SALESPERSON';
528:
529: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
530: l_salesrep_name ra_salesreps.NAME%TYPE;
531: l_sales_person okc_contacts_v.object1_id1%TYPE;
532: --stmathew - Bug 4372869/4222231..end
533: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
534: l_is_top_line number;
535: is_top_line_flag boolean;