APPS.JG_ZZ_AUDIT_AP_PKG SQL Statements

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

Line: 141

    INSERT INTO jg_zz_vat_trx_gt
            (
              jg_info_v1      -- Func Currency
             ,jg_info_v2      -- LE Entity Name
             ,jg_info_n1      -- LE Id
             ,jg_info_v3      -- LE Tax Payer ID
             ,jg_info_v4      -- LE Tax Registration Number
             ,jg_info_d1      -- Period Start Date
             ,jg_info_d2      -- Period End Date
             ,jg_info_v5      -- Status
             ,jg_info_v6      -- Company Name
             ,jg_info_v16     -- Registration Number --brathod, using jg_info_v16  instead of jg_info_n2
             ,jg_info_v7      -- Country
             ,jg_info_v8      -- Address1
             ,jg_info_v9      -- Address2
             ,jg_info_v10     -- Address3
             ,jg_info_v11     -- Address4
             ,jg_info_v12     -- City
             ,jg_info_v13     -- Postal Code
             ,jg_info_v14     -- Contact Person
             ,jg_info_v15     -- Phone Number
             ,jg_info_v30
             )
      VALUES(
              l_func_curr_code
             ,l_company_name  ----l_rep_entity_name changed for bug # 5494424
             ,l_legal_entity_id
             ,l_registration_number ---l_taxpayer_id changed for bug # 5494424
             ,l_tax_registration
             ,l_period_start_date
             ,decode(nvl(P_REPORT_NAME,'ZZ'),'JEESDOCE',l_period_end_date_to,l_period_end_date)
             ,l_status
             ,l_company_name
             ,l_registration_number
             ,l_country
             ,l_address1
             ,l_address2
             ,l_address3
             ,l_address4
             ,l_city
             ,l_postal_code
             ,l_contact
             ,l_phone_number
             ,'H'
             );