APPS.PAY_US_TAX_INFO_PKG SQL Statements

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

Line: 53

SELECT
	sit_exists
INTO
	l_state_exist
FROM
	pay_us_state_tax_info_f	pustif,
	pay_us_states		pus
WHERE
	pus.state_code	 = pustif.state_code
AND	pus.state_abbrev = p_state_abbrev
AND     SIT_EXISTS = 'Y'
AND	p_date between effective_start_date
		and effective_end_date;

Line: 98

	SELECT
		COUNTY_TAX
	INTO
		l_lit_exist
	FROM
		pay_us_county_tax_info_f
	WHERE
		jurisdiction_code	 = p_jurisdiction_code
        AND     county_tax = 'Y'
	AND	p_date between effective_start_date
		and effective_end_date;

Line: 112

	SELECT
		CITY_TAX
	INTO
		l_lit_exist
	FROM
		pay_us_city_tax_info_f
	WHERE
		jurisdiction_code	 = p_jurisdiction_code
        AND     city_tax = 'Y'
	AND	p_date between effective_start_date
		and effective_end_date;

Line: 155

      SELECT 'Y'
      INTO l_exists
      FROM pay_us_state_tax_info_f pust
      WHERE state_code = substr(p_jurisdiction_code,1,2)
      AND   p_date between effective_start_date and effective_end_date
      AND   decode(decode(p_tax_type||'_'||p_ee_or_er
               , 'SDI_EE', to_char(SDI_EE_WAGE_LIMIT)
               , 'SDI_ER', to_char(SDI_ER_WAGE_LIMIT)
               , 'SIT_', SIT_EXISTS
               , 'SUI_EE', to_char(SUI_EE_WAGE_LIMIT)
               , 'SUI_ER', to_char(SUI_ER_WAGE_LIMIT)
               , 'STEIC_EE',STA_INFORMATION17
                        , 'UNKNOWN'), '', 'N', 'Y')
                    = 'Y';

Line: 173

      SELECT 'Y'
      INTO l_exists
      FROM pay_wc_funds pwf,
           pay_us_states pus
      WHERE pus.state_code = substr(p_jurisdiction_code,1,2)
      AND   pus.state_abbrev = pwf.state_code;