APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 2153: SELECT /*+ INDEX ( HEADER ZX_TRX_HEADERS_GT_U1 ) INDEX ( TRXLINES ZX_TRANSACTION_LINES_GT_U1 ) */

2149: l_rounding_rule_found BOOLEAN;
2150:
2151:
2152: CURSOR get_acct_site_info_csr IS
2153: SELECT /*+ INDEX ( HEADER ZX_TRX_HEADERS_GT_U1 ) INDEX ( TRXLINES ZX_TRANSACTION_LINES_GT_U1 ) */
2154: NVL(trxlines.ship_third_pty_acct_id,
2155: header.ship_third_pty_acct_id) ship_third_pty_acct_id,
2156: NVL(trxlines.bill_third_pty_acct_id,
2157: header.bill_third_pty_acct_id) bill_third_pty_acct_id,

Line 2169: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header

2165: header.bill_to_cust_acct_site_use_id) bill_to_cust_acct_site_use_id,
2166: NVL(header.related_doc_date, NVL(header.provnl_tax_determination_date,
2167: NVL(trxlines.adjusted_doc_date,
2168: NVL(trxlines.trx_line_date, header.trx_date)))) tax_determine_date
2169: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header
2170: WHERE header.application_id = p_event_class_rec.application_id
2171: AND header.entity_code = p_event_class_rec.entity_code
2172: AND header.event_class_code = p_event_class_rec.event_class_code
2173: AND header.trx_id = p_event_class_rec.trx_id