APPS.PAY_US_TAX_INFO_PKG dependencies on PAY_US_STATE_TAX_INFO_F

Line 58: pay_us_state_tax_info_f pustif,

54: sit_exists
55: INTO
56: l_state_exist
57: FROM
58: pay_us_state_tax_info_f pustif,
59: pay_us_states pus
60: WHERE
61: pus.state_code = pustif.state_code
62: AND pus.state_abbrev = p_state_abbrev

Line 157: FROM pay_us_state_tax_info_f pust

153: IF (p_tax_type <> 'WC' OR p_tax_type <> 'WC2') THEN
154: --
155: SELECT 'Y'
156: INTO l_exists
157: FROM pay_us_state_tax_info_f pust
158: WHERE state_code = substr(p_jurisdiction_code,1,2)
159: AND p_date between effective_start_date and effective_end_date
160: AND decode(decode(p_tax_type||'_'||p_ee_or_er
161: , 'SDI_EE', to_char(SDI_EE_WAGE_LIMIT)