eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_1099R_MAG_REPORTING dependencies on PAY_US_STATE_W2_V

Line 78: 08-DEC-2002 ahanda 115.15 Changed view to use pay_us_state_w2_v

74: only if sit = 0
75: 03-dec-2002 djoshi 115.13 Corrected typo
76: 07-DEC-2002 ahanda 115.14 Changed from clause to join to main
77: table instead of secure views.
78: 08-DEC-2002 ahanda 115.15 Changed view to use pay_us_state_w2_v
79: instead of pay_us_w2_state_v.
80: 19-MAY-2003 ahanda 115.16 2955696 Changed federal and state action_creation
81: cursor to add ff_contexts and get only
82: context of TAX_UNIT_ID.

Line 873: pay_us_state_w2_v psv,

869: 'select distinct paf.person_id
870: from --hr_soft_coding_keyflex hsck,
871: hr_organization_units hou,
872: per_all_assignments_f paf,
873: pay_us_state_w2_v psv,
874: pay_payroll_actions ppa
875: where ppa.payroll_action_id = :p_payroll_action_id
876: and hou.business_group_id + 0 = ppa.business_group_id + 0
877: and psv.tax_unit_id = hou.organization_id

Line 1032: pay_us_state_w2_v psv,

1028: paf.assignment_id,
1029: psv.w2_state_wages,
1030: psv.w2_state_income_tax
1031: from per_all_assignments_f paf,
1032: pay_us_state_w2_v psv,
1033: pay_payroll_actions ppa
1034: where ppa.payroll_action_id = cp_payroll_action_id
1035: and psv.year = to_number(to_char(ppa.effective_date, 'YYYY'))
1036: and psv.state_abbrev = ppa.report_qualifier