APPS.JG_ZZ_VAT_YEARLY_EXT_PKG SQL Statements

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

Line: 45

  SELECT DISTINCT jgvrs.source source
  FROM jg_zz_vat_rep_entities jgvre
       ,jg_zz_vat_rep_status jgvrs
  WHERE jgvrs.vat_reporting_entity_id = jgvre.vat_reporting_entity_id
   AND jgvre.vat_reporting_entity_id = ln_reporting_entity_id
   AND jgvrs.final_reporting_status_flag = 'S'
  AND jgvrs.tax_calendar_year = ln_tax_cal_year
  ORDER BY jgvrs.source;

Line: 56

  SELECT glp.period_name period_name
  FROM gl_periods glp
  WHERE glp.period_year = ln_tax_cal_year
   AND glp.period_set_name = lc_tax_cal_name
   AND glp.period_name NOT IN
    (SELECT jgvrs.tax_calendar_period period_name
     FROM jg_zz_vat_rep_entities jgvre,
          jg_zz_vat_rep_status jgvrs
     WHERE jgvrs.vat_reporting_entity_id = jgvre.vat_reporting_entity_id
     AND jgvre.vat_reporting_entity_id = ln_reporting_entity_id
     AND jgvrs.final_reporting_status_flag = 'S'
     AND jgvrs.source = lc_source
     AND jgvrs.tax_calendar_year = ln_tax_cal_year)
ORDER BY glp.period_name;

Line: 72

  SELECT DISTINCT jgvrs.tax_calendar_name
    FROM jg_zz_vat_rep_status jgvrs
    WHERE jgvrs.vat_reporting_entity_id = p_reporting_entity_id
     AND jgvrs.tax_calendar_year = p_tax_calendar_year;