DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_HEADERS_V

Line 4015: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

4011:
4012: l_not_found BOOLEAN := FALSE;
4013: l_amt NUMBER;
4014: l_found VARCHAR2(1);
4015: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
4016: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4017: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4018:
4019: l_rebook_yn VARCHAR2(1) := null;

Line 4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte

4025:
4026: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4027: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4028: SELECT khr.contract_number, qte.quote_number
4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4030: WHERE khr.id = chrID
4031: AND qte.id = qteID;
4032:
4033: /* Cursor to get the Fee Name. */