DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PAY_US_W2_STATE_V

Line 1296: pay_us_w2_state_v pws

1292: decode(state_abbrev, 'NJ', state_abbrev||nvl(replace(replace(state_ein,'-'),'/'),'NO STATE EIN'), state_abbrev||' '||nvl(state_ein,'NO STATE EIN')) state_ein,
1293: w2_box_17 sit_subject,
1294: w2_box_18 sit_withheld
1295: FROM
1296: pay_us_w2_state_v pws
1297: WHERE state_abbrev NOT IN ( 'AK','FL', 'NH','NV','SD','TN','TX','WA','WY')
1298: AND (w2_box_17 <> 0 OR w2_box_18 <> 0)
1299: AND assignment_action_id = p_asg_actid
1300: AND payroll_action_id = pactid