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_MAGW2_REPORTING dependencies on PAY_US_W2_LOCALITY_V

Line 296: FROM pay_us_w2_locality_v plv

292: 'ASSIGNMENT_ID=C', pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ID'),
293: 'DATE_EARNED=C', pay_magtape_generic.get_parameter_value('DATE_EARNED'),
294: 'TRANSFER_COUNTY=P', substr(PLV.jurisdiction,4,3),
295: 'JURISDICTION_CODE=C', PLV.jurisdiction
296: FROM pay_us_w2_locality_v plv
297: where plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
298: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
299: and plv.tax_type = 'COUNTY'
300: and plv.state_abbrev = 'IN'

Line 323: FROM pay_us_w2_locality_v plv

319: WHERE substr(pcv.jurisdiction_code,1,2) = substr(psv.jurisdiction_code,1,2) AND
320: pcv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
321: )
322: OR (0 = (SELECT NVL(sum(W2_BOX_21),0)
323: FROM pay_us_w2_locality_v plv
324: WHERE plv.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID')
325: AND plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
326: AND plv.tax_type = 'COUNTY'
327: AND plv.state_abbrev = 'IN'

Line 411: FROM pay_us_w2_locality_v plv

407: PUS.state_abbrev = 'OH'
408: AND (
409: ( 0 =
410: (SELECT nvl(sum(W2_BOX_21),0)
411: FROM pay_us_w2_locality_v plv
412: where plv.assignment_action_id = AA.assignment_action_id
413: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
414: and plv.tax_type = 'COUNTY SCHOOL'
415: and plv.state_abbrev = 'OH'

Line 419: FROM pay_us_w2_locality_v plv

415: and plv.state_abbrev = 'OH'
416: and substr(plv.jurisdiction,1,2) = substr(PSV.jurisdiction_code,1,2)))
417: or ( 0 =
418: (SELECT nvl(sum(W2_BOX_21),0)
419: FROM pay_us_w2_locality_v plv
420: where plv.assignment_action_id = AA.assignment_action_id
421: and plv.TAX_UNIT_ID = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
422: and plv.tax_type = 'CITY SCHOOL'
423: and plv.state_abbrev = 'OH'