APPS.JL_ZZ_SH_LIBRARY_1_PKG SQL Statements

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

Line: 10

  select count(*)
  into tot_rec
  from ap_lookup_codes lc,ap_tax_codes tc
  where lc.lookup_type = 'TAX TYPE'
  and tc.tax_type = 'ICMS'
  and lc.lookup_code = tc.tax_type
  and sysdate < nvl(lc.inactive_date, sysdate+1)
  and sysdate < nvl(tc.inactive_date, sysdate+1)
  and tc.name = sitevat;

Line: 31

  Select   meaning
    Into   p_label
    From   fnd_lookup_values_vl
    Where  lookup_type = 'JLZZ_AR_TX_LABEL'
      And  lookup_code = p_lookup_code
      And  enabled_flag = 'Y'
      And  view_application_id = 0
      And  security_group_id = 0;