APPS.JG_ZZ_TAX SQL Statements

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

Line: 47

       SELECT tax_method_code
       INTO   l_tax_method
       FROM   zx_product_options;

Line: 123

       SELECT tax_method_code,
              org_id
       INTO   l_tax_method,
              l_org_id
       FROM   zx_product_options;

Line: 166

          SELECT ctt.global_attribute4
          INTO   l_tax_code
          FROM   ra_cust_trx_types_all ctt,
                 ar_vat_tax_all vt
          WHERE  ctt.cust_trx_type_id = p_trx_type_id
          AND    ctt.org_id = vt.org_id
          AND    ctt.org_id = l_org_id
          AND    ctt.global_attribute4 = vt.tax_code
          AND    vt.set_of_books_id = p_set_of_books_id
          AND    p_trx_date between vt.start_date
                            and     nvl(vt.end_date,p_trx_date)
          AND    nvl(vt.enabled_flag,'Y') = 'Y'
          AND    nvl(vt.tax_class,'O') = 'O';