APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_ASSETS_B

Line 15800: FROM OKL_ASSETS_B AST

15796:
15797: -- Get all the assets of the sales quote
15798: CURSOR l_quoteassets_csr(cp_quote_id IN NUMBER) IS
15799: SELECT AST.ID asset_id, asset_number, install_site_id
15800: FROM OKL_ASSETS_B AST
15801: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15802: AND AST.PARENT_OBJECT_ID = cp_quote_id;
15803:
15804: -- Get Inv item and supplier

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 15820: AND cfo.source_table = 'OKL_ASSETS_B'

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'
15820: AND cfo.source_table = 'OKL_ASSETS_B'
15821: AND cfo.id = caf.cfo_id
15822: AND caf.cft_code = 'PAYMENT_SCHEDULE'
15823: AND caf.sts_code IN ('CURRENT', 'WORK')
15824: AND caf.id = cfl.caf_id