APPS.OKL_SO_CREDIT_APP_WF dependencies on OKC_K_LINES_B

Line 1547: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR

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
1548: WHERE chr.scs_code = 'QUOTE'
1549: AND chr.ID = l_quote_id
1550: AND CLEB.ID = KLE.ID
1551: AND CLEB.DNZ_CHR_ID = chr.ID