APPS.PAY_US_ADHOC_UTILS dependencies on PAY_US_W2_TAX_UNIT_V

Line 138: from pay_us_w2_tax_unit_v

134: -- Pass the p_type = 'NAME' to get the 2678 name.
135:
136: if p_type = 'EIN' then
137: SELECT FEDERAL_EIN into v_name
138: from pay_us_w2_tax_unit_v
139: where TAX_UNIT_ID = p_commonpay_agent_id
140: and year = p_year;
141:
142: elsif p_type = 'NAME' then

Line 145: from pay_us_w2_tax_unit_v

141:
142: elsif p_type = 'NAME' then
143:
144: SELECT tax_unit_name into v_name
145: from pay_us_w2_tax_unit_v
146: where TAX_UNIT_ID = p_commonpay_agent_id
147: and year = p_year;
148: end if;
149: return(v_name);