APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_TAX_SOURCES

Line 2469: FROM OKL_TAX_SOURCES

2465:
2466: -- Check if upfront tax calculation has happened for this quote
2467: CURSOR c_chk_tax_calculation (p_quote_id OKL_LEASE_QUOTES_B.ID%TYPE) IS
2468: SELECT 'X'
2469: FROM OKL_TAX_SOURCES
2470: WHERE tax_call_type_code = 'UPFRONT_TAX'
2471: AND ENTITY_CODE ='SALES_QUOTES'
2472: AND trx_id = p_quote_id;
2473:

Line 3599: FROM okl_tax_sources

3595: l_expense_level_tbl okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type;
3596:
3597: CURSOR l_get_assets_tax_amount(cp_quote_id IN NUMBER) IS
3598: SELECT SUM(total_tax)
3599: FROM okl_tax_sources
3600: WHERE trx_id = cp_quote_id
3601: AND asset_number IS NOT NULL
3602: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3603: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE

Line 3621: FROM okl_tax_sources

3617: AND parent_object_code = 'LEASEQUOTE';
3618:
3619: CURSOR l_get_asset_tax_amount(cp_quote_id IN NUMBER, cp_asset_number IN VARCHAR2) IS
3620: SELECT total_tax
3621: FROM okl_tax_sources
3622: WHERE trx_id = cp_quote_id
3623: AND asset_number = cp_asset_number
3624: AND entity_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_ENTITY_CODE
3625: AND event_class_code = OKL_PROCESS_SALES_TAX_PVT.G_SQ_EVENT_CLASS_CODE