52:
53: -- get org_id for contract
54: CURSOR c_get_org_id(cp_contract_num IN VARCHAR2) IS
55: SELECT authoring_org_id
56: FROM okc_k_headers_b
57: WHERE contract_number = cp_contract_num;
58:
59: -- get new batch details
60: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
984:
985: -- get org_id for contract
986: CURSOR c_get_org_id(cp_contract_num IN VARCHAR2) IS
987: SELECT authoring_org_id
988: FROM okc_k_headers_b
989: WHERE contract_number = cp_contract_num;
990:
991: ----------
992: