APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_ASSETS_B

Line 15728: FROM OKL_ASSETS_B AST

15724:
15725: -- Get all the assets of the sales quote
15726: CURSOR l_quoteassets_csr(cp_quote_id IN NUMBER) IS
15727: SELECT AST.ID asset_id, asset_number, install_site_id
15728: FROM OKL_ASSETS_B AST
15729: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15730: AND AST.PARENT_OBJECT_ID = cp_quote_id;
15731:
15732: -- Get Inv item and supplier

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

15739: -- Get the quote and asset level cash flows for a sales quote
15740: CURSOR l_q_asset_cashflows_csr(cp_quote_id IN NUMBER) IS
15741: SELECT cfo.source_id , ast.asset_number, caf.sty_id,
15742: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15743: FROM OKL_ASSETS_B ast, okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15744: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15745: AND AST.PARENT_OBJECT_ID = cp_quote_id
15746: AND ast.id = cfo.source_id
15747: AND cfo.oty_code = 'QUOTED_ASSET'

Line 15748: AND cfo.source_table = 'OKL_ASSETS_B'

15744: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15745: AND AST.PARENT_OBJECT_ID = cp_quote_id
15746: AND ast.id = cfo.source_id
15747: AND cfo.oty_code = 'QUOTED_ASSET'
15748: AND cfo.source_table = 'OKL_ASSETS_B'
15749: AND cfo.id = caf.cfo_id
15750: AND caf.cft_code = 'PAYMENT_SCHEDULE'
15751: AND caf.sts_code IN ('CURRENT', 'WORK')
15752: AND caf.id = cfl.caf_id