APPS.PAY_1099R_PKG dependencies on PAY_US_W2_STATE_V

Line 1280: pay_us_w2_state_v pws

1276: decode(state_abbrev, 'NJ', state_abbrev||nvl(replace(replace(state_ein,'-'),'/'),'NO STATE EIN'), state_abbrev||' '||nvl(state_ein,'NO STATE EIN')) state_ein,
1277: w2_box_17 sit_subject,
1278: w2_box_18 sit_withheld
1279: FROM
1280: pay_us_w2_state_v pws
1281: WHERE state_abbrev NOT IN ( 'AK','FL', 'NH','NV','SD','TN','TX','WA','WY')
1282: AND (w2_box_17 <> 0 OR w2_box_18 <> 0)
1283: AND assignment_action_id = p_asg_actid
1284: AND payroll_action_id = pactid