APPS.OKL_AM_RV_WRITEDOWN_PVT dependencies on OKL_K_LINES_FULL_V

Line 74: FROM okl_k_lines_full_v l, okc_k_headers_b h

70:
71: -- This cursor selects line item fields and contract status for a given line ID
72: CURSOR l_linesfullv_csr(p_id NUMBER) IS
73: SELECT l.name, l.item_description, l.residual_value, l.oec, l.chr_id, h.contract_number
74: FROM okl_k_lines_full_v l, okc_k_headers_b h
75: WHERE l.chr_id = h.id
76: AND l.id = p_id;
77: -- we can use chr_id in the above cursor as we will be pulling data only for the TOP LINE (Financial Asset) which
78: -- will always have the chr_id.

Line 93: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okl_k_lines_full_v l

89:
90: -- This cursor is used to check if an accepted termination quote exists for an asset line.
91: CURSOR l_quotes_csr(p_kle_id NUMBER) IS
92: SELECT l.name
93: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okl_k_lines_full_v l
94: WHERE qh.id = ql.qte_id
95: AND qh.qst_code = 'ACCEPTED'
96: AND ql.qlt_code = 'AMCFIA'
97: AND ql.kle_id = l.id