APPS.JG_ZZ_JGZZALRL_PKG SQL Statements

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

Line: 7

      Select entity_identifier
      Into l_entity_identifier
      From JG_ZZ_VAT_REP_ENTITIES
      where vat_reporting_entity_id = p_vat_reporting_entity_id;

Line: 21

      select meaning
      Into l_source
      From FND_LOOKUP_VALUES
      Where lookup_type='JGZZ_SOURCE'
      And lookup_code = p_source
      And language = userenv('LANG');

Line: 37

      Select meaning
      Into l_fin_tran_type
      From FND_LOOKUP_VALUES
      Where ( (p_source = 'AP'
               and lookup_type = 'JGZZ_AP_OF_TRANS_TYPE')
             Or
              (p_source = 'AR'
               and lookup_type = 'JGZZ_AR_OF_TRANS_TYPE')
             Or
              (p_source = 'GL'
               and lookup_type = 'JGZZ_GL_OF_TRANS_TYPE')
             Or
              (p_source = 'ALL'
               and lookup_type in ('JGZZ_AP_OF_TRANS_TYPE'
                                  ,'JGZZ_AR_OF_TRANS_TYPE'
                                  ,'JGZZ_GL_OF_TRANS_TYPE')))
      And lookup_code = p_fin_tran_type
      And language = userenv('LANG');

Line: 65

      Select meaning
      Into l_vat_tran_type
      From FND_LOOKUP_VALUES
      Where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
      And lookup_code = p_vat_tran_type
      And language = userenv('LANG');

Line: 81

      Select tax_status_code
      Into l_tax_status_code
      From ZX_STATUS_B
      Where tax = nvl(p_tax_code,tax)
      And tax_regime_code = nvl(p_vat_regime,tax_regime_code)
      And tax_status_id = p_tax_status;

Line: 97

      Select rates.TAX_RATE_CODE
      Into l_tax_rate_code
      From ZX_RATES_B rates
      Where rates.tax_rate_id = p_tax_rate_id;

Line: 112

      Select meaning
      Into l_tax_box
      From fnd_lookup_values
      WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
      And lookup_code = p_tax_box
      And language = userenv('LANG');

Line: 128

      Select meaning
      Into l_non_rec_tax_box
      From fnd_lookup_values
      WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
      And lookup_code = p_non_rec_tax_box
      And language = userenv('LANG');

Line: 144

      Select meaning
      Into l_taxable_box
      From fnd_lookup_values
      WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
      And lookup_code = p_taxable_box
      And language = userenv('LANG');

Line: 160

      Select meaning
      Into l_non_rec_taxable_box
      From fnd_lookup_values
      WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
      And lookup_code = p_non_rec_taxable_box
      And language = userenv('LANG');