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_PAYROLL_ACTIONS

Line 89: pay_payroll_actions PPA

85: 'TRANSFER_2678_FILER=P', 'N',
86: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id
87: FROM pay_state_rules SR,
88: hr_organization_information HOI,
89: pay_payroll_actions PPA
90: WHERE HOI.organization_id =
91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
92: AND SR.state_code =
93: pay_magtape_generic.get_parameter_value('TRANSFER_STATE')

Line 109: pay_payroll_actions PPA

105: 'TRANSFER_COUNTY=P', '-1',
106: 'TRANSFER_2678_FILER=P', HOI.org_information8,
107: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id -- payroll_action_id of YREND
108: FROM hr_organization_information HOI,
109: pay_payroll_actions PPA
110: WHERE HOI.organization_id =
111: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
112: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
113: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 138: pay_payroll_actions ppa,

134: FROM ff_archive_item_contexts faic,
135: ff_archive_items fai,
136: ff_contexts ffc,
137: ff_database_items fdi,
138: pay_payroll_actions ppa,
139: pay_assignment_actions AA
140: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
141: ('TRANSFER_PAYROLL_ACTION_ID')
142: AND ppa.report_type = 'YREND'

Line 174: pay_payroll_actions PA

170: FROM per_people_f PE,
171: per_assignments_f SS,
172: pay_action_interlocks AI,
173: pay_assignment_actions AA,
174: pay_payroll_actions PA
175: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID') AND
177: AA.payroll_action_id = PA.payroll_action_id AND
178: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 208: pay_payroll_actions PA,

204: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
205: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
206: 'BUSINESS_GROUP_ID=C', PA.business_group_id
207: FROM pay_state_rules SR,
208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
210: pay_payroll_actions PA1
211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
212: AND AA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 210: pay_payroll_actions PA1

206: 'BUSINESS_GROUP_ID=C', PA.business_group_id
207: FROM pay_state_rules SR,
208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
210: pay_payroll_actions PA1
211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
212: AND AA.payroll_action_id = pay_magtape_generic.get_parameter_value
213: ('TRANSFER_PAYROLL_ACTION_ID')
214: AND AA.serial_number IS NULL

Line 237: pay_payroll_actions PA

233: per_assignments_f SS,
234: pay_state_rules SR,
235: pay_action_interlocks AI,
236: pay_assignment_actions AA,
237: pay_payroll_actions PA
238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
239: ('TRANSFER_PAYROLL_ACTION_ID') AND
240: AA.payroll_action_id = PA.payroll_action_id AND
241: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 270: pay_payroll_actions PA

266: FROM per_people_f PE,
267: per_assignments_f SS,
268: pay_action_interlocks AI,
269: pay_assignment_actions AA,
270: pay_payroll_actions PA
271: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
272: ('TRANSFER_PAYROLL_ACTION_ID') AND
273: AA.payroll_action_id = PA.payroll_action_id AND
274: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 347: pay_payroll_actions PA,

343: 'JURISDICTION_CODE=C', PMV.jurisdiction_code
344: FROM
345: pay_us_states PUS,
346: pay_us_arch_mag_county_sd_v PMV,
347: pay_payroll_actions PA,
348: pay_assignment_actions AA
349:
350: WHERE
351: AA.assignment_action_id = pay_magtape_generic.get_parameter_value('YREND_ASSIGNMENT_ACTION_ID') AND

Line 373: pay_payroll_actions PA

369: FROM
370: pay_us_states PUS,
371: pay_us_arch_mag_city_sd_v PMC,
372: pay_assignment_actions AA,
373: pay_payroll_actions PA
374: WHERE
375:
376: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
377: ('YREND_ASSIGNMENT_ACTION_ID') AND

Line 399: pay_payroll_actions PA

395: FROM
396: pay_us_states PUS,
397: pay_us_arch_mag_state_v PSV,
398: pay_assignment_actions AA,
399: pay_payroll_actions PA
400: WHERE
401: AA.assignment_action_id = pay_magtape_generic.get_parameter_value
402: ('YREND_ASSIGNMENT_ACTION_ID') AND
403: AA.payroll_action_id = PA.payroll_action_id AND

Line 439: pay_payroll_actions ppa

435: FROM per_people_f ppf,
436: per_assignments_f paf,
437: pay_assignment_actions paa,
438: hr_tax_units_v tuv,
439: pay_payroll_actions ppa
440: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
441: ('TRANSFER_PAYROLL_ACTION_ID') AND
442: paa.payroll_action_id = ppa.payroll_action_id AND
443: paa.tax_unit_id = tuv.tax_unit_id and