APPS.PAY_US_W2_INFO_PKG dependencies on PAY_US_STATE_W2_V

Line 491: FROM pay_us_state_w2_v state

487: SELECT 1 , substr(state_abbrev,1,2) state_code,
488: substr(state_ein,1,20) state_ein,
489: to_char(decode(W2_STATE_WAGES,0,'',W2_STATE_WAGES),'9999999990.99') state_wages,
490: to_char(decode(W2_STATE_INCOME_TAX,0,'',W2_STATE_INCOME_TAX),'9999999990.99') state_tax
491: FROM pay_us_state_w2_v state
492: WHERE assignment_action_id = p_asg_action_id
493: and ( (w2_state_wages > 0) or
494: (W2_STATE_INCOME_TAX > 0) ) /* 6809739 */
495: and state_ein <> 'FLI P.P. #'

Line 501: FROM pay_us_state_w2_v state

497: SELECT 2 , substr(state_abbrev,1,2) state_code,
498: substr(state_ein,1,20) state_ein,
499: nvl(W2_STATE_WAGES,'') state_wages,
500: trim(decode(to_char(to_number(W2_STATE_INCOME_TAX ),'9999999990.99'),'0.0' , ' ',to_char(to_number(W2_STATE_INCOME_TAX ),'9999999990.99') || ' - FLI' )) state_tax
501: FROM pay_us_state_w2_v state
502: WHERE assignment_action_id = p_asg_action_id
503: and ( (w2_state_wages <> ' ') or
504: (to_char(to_number(W2_STATE_INCOME_TAX ),'9999999990.99') <> 0) ) /* 6809739 */
505: and state_ein = 'FLI P.P. #'