DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on ZX_LINES

Line 1296: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,

1292: -- This procedure logic will be executed in its entirety, only if SLA accounting
1293: -- option AMB is enabled.
1294: -- When enabled, it creates:
1295: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
1296: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
1297: -- store values for cle-id, tax_line_id, tax_amount, etc.
1298: -- 3. Identify tax treatment for each asset line, to derive stream type
1299: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
1300: -- Business Rules :

Line 1365: , zx_lines txl

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
1369: AND txs.tax_line_status_code = 'ACTIVE'