DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_HEADERS_V

Line 4002: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

3998:
3999: l_not_found BOOLEAN := FALSE;
4000: l_amt NUMBER;
4001: l_found VARCHAR2(1);
4002: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
4003: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4004: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4005:
4006: l_rebook_yn VARCHAR2(1) := null;

Line 4016: FROM okc_k_headers_v khr,okl_trx_quotes_b qte

4012:
4013: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4014: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4015: SELECT khr.contract_number, qte.quote_number
4016: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4017: WHERE khr.id = chrID
4018: AND qte.id = qteID;
4019:
4020: /* Cursor to get the Fee Name. */