DBA Data[Home] [Help]

APPS.OKL_AM_RECYCLE_TRMNT_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 42: FROM OKL_K_HEADERS_FULL_V

38: CURSOR get_recycle_k_vals_csr (p_khr_id IN NUMBER) IS
39: SELECT id,
40: contract_number,
41: sts_code
42: FROM OKL_K_HEADERS_FULL_V
43: WHERE id = p_khr_id;
44:
45: get_recycle_vals_rec get_recycle_vals_csr%ROWTYPE;
46: get_recycle_k_vals_rec get_recycle_k_vals_csr%ROWTYPE;

Line 232: OKL_K_HEADERS_FULL_V K

228: -- Cursor to get the contract details for the transaction being recycled
229: CURSOR contract_details_csr ( p_tcn_id IN NUMBER) IS
230: SELECT K.contract_number
231: FROM OKL_TRX_CONTRACTS T,
232: OKL_K_HEADERS_FULL_V K
233: WHERE T.id = p_tcn_id
234: AND T.khr_id = K.id;
235:
236: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;