APPS.PAY_US_TAX_INFO_PKG dependencies on PAY_US_STATES

Line 59: pay_us_states pus

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
63: AND SIT_EXISTS = 'Y'

Line 176: pay_us_states pus

172: --
173: SELECT 'Y'
174: INTO l_exists
175: FROM pay_wc_funds pwf,
176: pay_us_states pus
177: WHERE pus.state_code = substr(p_jurisdiction_code,1,2)
178: AND pus.state_abbrev = pwf.state_code;
179: /* How about business_group_id too ? */
180: RETURN l_exists;