APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_QUOTES_B

Line 2325: okl_trx_quotes_b qte,

2321: fin_ast_cle.name
2322: FROM okc_k_lines_v fin_ast_cle,
2323: okc_k_headers_b chr,
2324: okc_line_styles_b fin_ast_lse,
2325: okl_trx_quotes_b qte,
2326: okl_txl_quote_lines_b tql
2327: WHERE chr.id = p_orig_chr_id
2328: AND fin_ast_cle.chr_id = chr.id
2329: AND fin_ast_cle.dnz_chr_id = chr.id

Line 2347: okl_trx_quotes_b qte,

2343: SELECT fin_ast_cle.id,
2344: fin_ast_cle.name
2345: FROM okl_txl_cntrct_lns tcl,
2346: okc_k_lines_v fin_ast_cle,
2347: okl_trx_quotes_b qte,
2348: okl_txl_quote_lines_b tql
2349: WHERE tcl.tcn_id = p_source_trx_id
2350: AND tcl.before_transfer_yn = 'N'
2351: AND fin_ast_cle.chr_id = p_orig_chr_id

Line 2432: FROM okl_trx_quotes_b

2428:
2429: --Cusor for obtaining the last accepted termination quote date.
2430: CURSOR last_trq_date_csr(p_contract_id IN NUMBER) IS
2431: SELECT max(date_accepted)
2432: FROM okl_trx_quotes_b
2433: WHERE khr_id = p_contract_id
2434: AND QST_CODE = 'ACCEPTED';
2435:
2436: -- Cursor for obtaining the last credit memo date