41: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
42: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
43: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
44: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
45: trx_level_type zx_trx_tax_link_gt.trx_level_type%TYPE,
46: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
47: line_amt zx_trx_tax_link_gt.line_amt%TYPE
48: -- trx_date zx_trx_headers_gt.trx_date%TYPE,
49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
42: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
43: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
44: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
45: trx_level_type zx_trx_tax_link_gt.trx_level_type%TYPE,
46: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
47: line_amt zx_trx_tax_link_gt.line_amt%TYPE
48: -- trx_date zx_trx_headers_gt.trx_date%TYPE,
49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: -- precision zx_trx_headers_gt.precision%TYPE,
43: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
44: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
45: trx_level_type zx_trx_tax_link_gt.trx_level_type%TYPE,
46: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
47: line_amt zx_trx_tax_link_gt.line_amt%TYPE
48: -- trx_date zx_trx_headers_gt.trx_date%TYPE,
49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: -- precision zx_trx_headers_gt.precision%TYPE,
51: -- trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
1554: ,allocgt.TRX_LEVEL_TYPE
1555: ,allocgt.TRX_LINE_ID
1556: ,allocgt.LINE_AMT
1557: FROM zx_import_tax_lines_gt taxgt,
1558: zx_trx_tax_link_gt allocgt
1559: WHERE taxgt.application_id = p_event_class_rec.application_id
1560: AND taxgt.entity_code = p_event_class_rec.entity_code
1561: AND taxgt.event_class_code = p_event_class_rec.event_class_code
1562: AND taxgt.trx_id = p_event_class_rec.trx_id