APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_TRANSACTION_LINES_GT

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

2141: l_rounding_rule_found BOOLEAN;
2142:
2143:
2144: CURSOR get_acct_site_info_csr IS
2145: SELECT /*+ INDEX ( HEADER ZX_TRX_HEADERS_GT_U1 ) INDEX ( TRXLINES ZX_TRANSACTION_LINES_GT_U1 ) */
2146: NVL(trxlines.ship_third_pty_acct_id,
2147: header.ship_third_pty_acct_id) ship_third_pty_acct_id,
2148: NVL(trxlines.bill_third_pty_acct_id,
2149: header.bill_third_pty_acct_id) bill_third_pty_acct_id,

Line 2161: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header

2157: header.bill_to_cust_acct_site_use_id) bill_to_cust_acct_site_use_id,
2158: NVL(header.related_doc_date, NVL(header.provnl_tax_determination_date,
2159: NVL(trxlines.adjusted_doc_date,
2160: NVL(trxlines.trx_line_date, header.trx_date)))) tax_determine_date
2161: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header
2162: WHERE header.application_id = p_event_class_rec.application_id
2163: AND header.entity_code = p_event_class_rec.entity_code
2164: AND header.event_class_code = p_event_class_rec.event_class_code
2165: AND header.trx_id = p_event_class_rec.trx_id