DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on ZX_LINES

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

1260: -- This procedure logic will be executed in its entirety, only if SLA accounting
1261: -- option AMB is enabled.
1262: -- When enabled, it creates:
1263: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
1264: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
1265: -- store values for cle-id, tax_line_id, tax_amount, etc.
1266: -- 3. Identify tax treatment for each asset line, to derive stream type
1267: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
1268: -- Business Rules :

Line 1333: , zx_lines txl

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