DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_TAX_SOURCES

Line 3499: FROM okl_tax_sources

3495: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3496:
3497: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3498: SELECT SUM(total_tax)
3499: FROM okl_tax_sources
3500: WHERE trx_id = cp_quote_id
3501: AND asset_number IS NOT NULL
3502: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3503: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

Line 3521: FROM okl_tax_sources

3517: AND parent_object_code = 'LEASEQUOTE';
3518:
3519: CURSOR l_get_asset_tax_amount(cp_quote_id IN NUMBER, cp_asset_number IN VARCHAR2) IS
3520: SELECT total_tax
3521: FROM okl_tax_sources
3522: WHERE trx_id = cp_quote_id
3523: AND asset_number = cp_asset_number
3524: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3525: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE