APPS.OKL_SO_CREDIT_APP_WF dependencies on OKC_K_HEADERS_B

Line 645: SELECT INV_ORGANIZATION_ID FROM OKC_K_HEADERS_B

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

Line 1365: l_quote_number OKC_K_HEADERS_B.CONTRACT_number%TYPE;

1361: x_msg_data VARCHAR2(2000);
1362: x_msg_count NUMBER := 0 ;
1363: l_api_version NUMBER := 1.0 ;
1364: x_return_status VARCHAR2(1) ;
1365: l_quote_number OKC_K_HEADERS_B.CONTRACT_number%TYPE;
1366:
1367: CURSOR contract_number_csr(p_contract_id NUMBER ) IS
1368: SELECT SUM(KLE.CAPITAL_AMOUNT) ,chr.contract_number
1369: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR