DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TAX_SOURCES

Line 215: FROM OKL_TAX_SOURCES

211: -- dcshanmu bug 6673102 start
212: CURSOR c_upfront_tax_calc(p_contract_id IN NUMBER)
213: IS
214: SELECT 'X'
215: FROM OKL_TAX_SOURCES
216: WHERE KHR_ID = p_contract_id
217: AND TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
218: AND TAX_LINE_STATUS_CODE = 'ACTIVE';
219: -- dcshanmu bug 6673102 end

Line 1332: FROM okl_tax_sources txs

1328: , txs.kle_id asset_id
1329: , txs.id tax_header_id
1330: , txl.tax_line_id tax_line_id
1331: , txl.tax_amt tax_amount
1332: FROM okl_tax_sources txs
1333: , zx_lines txl
1334: WHERE txs.khr_id = p_contract_id
1335: AND txs.kle_id = p_line_id
1336: AND txs.trx_id = p_transaction_id

Line 1788: FROM okl_tax_sources TAXS

1784: WHERE org_id = cp_org_id;
1785:
1786: CURSOR c_get_tax_amt_csr(cp_trx_id IN NUMBER,cp_khr_id IN NUMBER,cp_kle_id IN NUMBER) IS
1787: SELECT nvl(sum(total_tax) ,0)
1788: FROM okl_tax_sources TAXS
1789: WHERE TAXS.TAX_LINE_STATUS_CODE = 'ACTIVE'
1790: AND TAXS.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'
1791: AND TAXS.ENTITY_CODE = 'ASSETS'
1792: AND TAXS.APPLICATION_ID = 540