APPS.OKL_SO_CREDIT_APP_WF dependencies on OKC_K_HEADERS_B

Line 648: SELECT INV_ORGANIZATION_ID FROM OKC_K_HEADERS_B

644: WHERE credit_req_id = b_credit_request_id;
645:
646: -- cursor to get inventory org id of the sales quote
647: CURSOR c_get_inv_org_id (p_qte_id IN NUMBER) IS
648: SELECT INV_ORGANIZATION_ID FROM OKC_K_HEADERS_B
649: WHERE ID = p_qte_id;
650:
651: CURSOR c_recommendation (b_request_id IN NUMBER) IS
652: SELECT credit_recommendation,

Line 1543: l_quote_number OKC_K_HEADERS_B.CONTRACT_number%TYPE;

1539: x_msg_data VARCHAR2(2000);
1540: x_msg_count NUMBER := 0 ;
1541: l_api_version NUMBER := 1.0 ;
1542: x_return_status VARCHAR2(1) ;
1543: l_quote_number OKC_K_HEADERS_B.CONTRACT_number%TYPE;
1544:
1545: CURSOR contract_number_csr(p_contract_id NUMBER ) IS
1546: SELECT SUM(KLE.CAPITAL_AMOUNT) ,chr.contract_number
1547: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR