DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 15815: FROM OKL_ASSETS_B ast, okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl

15811: -- Get the quote and asset level cash flows for a sales quote
15812: CURSOR l_q_asset_cashflows_csr(cp_quote_id IN NUMBER) IS
15813: SELECT cfo.source_id , ast.asset_number, caf.sty_id,
15814: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15815: FROM OKL_ASSETS_B ast, okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15816: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15817: AND AST.PARENT_OBJECT_ID = cp_quote_id
15818: AND ast.id = cfo.source_id
15819: AND cfo.oty_code = 'QUOTED_ASSET'

Line 15829: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl

15825: GROUP BY cfo.source_id , ast.asset_number, caf.sty_id
15826: UNION
15827: SELECT cfo.source_id , null, caf.sty_id,
15828: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15829: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15830: WHERE cfo.oty_code = 'LEASE_QUOTE'
15831: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
15832: AND cfo.source_id = cp_quote_id
15833: AND cfo.id = caf.cfo_id