[Home] [Help]
28: acct_rec acct_csr%ROWTYPE;
29:
30: --Cursors to fetch the information to be printed on the report
31: -- Changed by Santonyr on 02 Apr 2004
32: -- Changed okl_trx_types_tl to okl_trx_types_v in the cursor
33: -- select statement as it retrives the records with other languages too
34:
35: CURSOR tcn_csr (p_source_id NUMBER) IS
36: SELECT khr.contract_number,
42: tcl.amount line_amount
43: FROM okl_trx_contracts_all tcn,
44: okl_txl_cntrct_lns_all tcl,
45: okl_strm_type_tl sty,
46: okl_trx_types_v try,
47: okc_k_headers_all_b khr
48: WHERE tcl.id = p_source_id
49: AND tcn.id = tcl.tcn_id
50: AND tcl.sty_id = sty.id(+)
53: --added by rkuttiya for MultiGAAP Project
54: AND tcn.set_of_books_id = p_ledger_id;
55:
56: -- Changed by Santonyr on 02 Apr 2004
57: -- Changed okl_trx_types_tl to okl_trx_types_v in the cursor
58: -- select statement as it retrives the records with other languages too
59:
60: --rkuttiya commented out following cursor for MultiGAAP Project
61: --no longer needed
67: tal.line_number,
68: tal.original_cost line_amount
69: FROM okl_trx_assets tas,
70: okl_txl_assets_b tal,
71: okl_trx_types_v try,
72: okc_k_headers_all_b khr
73: WHERE tal.id = p_source_id
74: AND tas.id = tal.tas_id
75: AND tas.try_id = try.id