APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TAX_SOURCES

Line 247: FROM OKL_TAX_SOURCES

243: -- dcshanmu bug 6673102 start
244: CURSOR c_upfront_tax_calc(p_contract_id IN NUMBER)
245: IS
246: SELECT 'X'
247: FROM OKL_TAX_SOURCES
248: WHERE KHR_ID = p_contract_id
249: AND TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
250: AND TAX_LINE_STATUS_CODE = 'ACTIVE';
251: -- dcshanmu bug 6673102 end

Line 1364: FROM okl_tax_sources txs

1360: , txs.kle_id asset_id
1361: , txs.id tax_header_id
1362: , txl.tax_line_id tax_line_id
1363: , txl.tax_amt tax_amount
1364: FROM okl_tax_sources txs
1365: , zx_lines txl
1366: WHERE txs.khr_id = p_contract_id
1367: AND txs.kle_id = p_line_id
1368: AND txs.trx_id = p_transaction_id

Line 1820: FROM okl_tax_sources TAXS

1816: WHERE org_id = cp_org_id;
1817:
1818: CURSOR c_get_tax_amt_csr(cp_trx_id IN NUMBER,cp_khr_id IN NUMBER,cp_kle_id IN NUMBER) IS
1819: SELECT nvl(sum(total_tax) ,0)
1820: FROM okl_tax_sources TAXS
1821: WHERE TAXS.TAX_LINE_STATUS_CODE = 'ACTIVE'
1822: AND TAXS.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
1823: AND TAXS.ENTITY_CODE = 'ASSETS'
1824: AND TAXS.APPLICATION_ID = 540