DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

                 SELECT 'Invalid tax Code'
                 INTO    l_temp
                 From    Dual
                 Where exists
                 ( Select line.vat_tax_id
                 FROM   ra_customer_trx_lines line,
                        ar_vat_tax tax
                 WHERE  line.customer_trx_id      = p_customer_trx_id
                 AND    line.line_type            = 'LINE'
                 AND    line.vat_tax_id           = tax.vat_tax_id
                 AND    p_trx_date  NOT BETWEEN tax.start_date
                                             AND NVL(tax.end_date,
                                                     p_trx_date));