APPS.PAY_AC_TAXABILITY_CHK_ROW SQL Statements

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

Line: 55

  select state_abbrev,state_code
  from pay_us_states
  where state_code  <= '51';

Line: 100

  select state_abbrev
  from pay_us_states
  where state_code <= '51';

Line: 107

  select city_name
  from pay_us_city_names
  where state_code = cp_state_code
  and city_code = cp_city_code
  and primary_flag = 'Y';

Line: 116

  select county_name
  from pay_us_counties
  where state_code = cp_state_code
  and county_code = cp_county_code;

Line: 187

  SELECT nvl(status,'Y')
  FROM pay_taxability_rules
  where  tax_type = cp_tax_type
  and tax_category =  cp_tax_category
  and classification_id = cp_classification_id
  and jurisdiction_code = cp_jurisdiction_code
  and legislation_code = cp_legislation_code;