0 Replies Latest reply: Jun 24, 2013 5:37 AM by Ramu RSS

    pay_us_wages_w2_v is not picking current year data?

    Ramu

      Hi,

      pay_us_wages_w2_v tabe is not getting current year data, only is getting previous year data.

      Like

      SELECT sum(w2_wages_tips_compensation)
      FROM   pay_us_wages_w2_v puw
      WHERE  puw.assignment_id = 40291--:assignment_id1
      ANDpuw.year      = '2013'--TO_CHAR(:P_PAY_DATE_END,'RRRR');

       

      Please let me know , if any body idea?. We have to run any Program?

       

      Thanks,

      Ramu