APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_O2C_CALC_TXN_INPUT_V

Line 715: From ZX_O2C_CALC_TXN_INPUT_V;

711: line_date5 ,
712: exempt_certificate_number ,
713: exempt_reason ,
714: exemption_control_flag
715: From ZX_O2C_CALC_TXN_INPUT_V;
716: -- WHERE transaction_id = p_trx_id;
717:
718: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TAX_API';
719: l_return_status VARCHAR2(30);

Line 1286: ' Records in ZX_O2C_CALC_TXN_INPUT_V = '||pg_trx_id_tab.last);

1282: ELSE /*The view has returned some rows that can be processed below */
1283:
1284: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1285: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1286: ' Records in ZX_O2C_CALC_TXN_INPUT_V = '||pg_trx_id_tab.last);
1287: END IF;
1288:
1289: For ptr in 1..nvl(pg_trx_id_tab.last, 0) loop
1290:

Line 1367: FROM ZX_O2C_CALC_TXN_INPUT_V

1363: END IF;
1364:
1365: SELECT SUM(ABS(line_amount))
1366: INTO l_doc_amount
1367: FROM ZX_O2C_CALC_TXN_INPUT_V
1368: WHERE transaction_id = l_doc_trx_id;
1369:
1370: SET_DOCUMENT_TYPE(l_document_type,pg_adj_doc_trx_id_tab(I),l_doc_amount,pg_line_level_action_tab(I),l_return_status);
1371:

Line 4662: from ZX_O2C_CALC_TXN_INPUT_V

4658:
4659: BEGIN
4660: select line_amount, adjusted_doc_transaction_id, line_level_action
4661: into l_amount,l_adj_trx_id,l_line_action
4662: from ZX_O2C_CALC_TXN_INPUT_V
4663: where transaction_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt)
4664: and transaction_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt);
4665: EXCEPTION
4666: when others then

Line 4968: from ZX_O2C_CALC_TXN_INPUT_V

4964:
4965: BEGIN
4966: select line_amount, adjusted_doc_transaction_id, line_level_action
4967: into l_amount,l_adj_trx_id,l_line_action
4968: from ZX_O2C_CALC_TXN_INPUT_V
4969: where transaction_id = SYNC_TAX_LINES.transaction_id(sync_tax_cnt1)
4970: and transaction_line_id = SYNC_TAX_LINES.transaction_line_id(sync_tax_cnt1);
4971: EXCEPTION
4972: when others then