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_ASSIGNMENT_ACTIONS

Line 139: pay_assignment_actions AA

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'
143: AND to_char(ppa.effective_date,'YYYY') =

Line 173: pay_assignment_actions AA,

169: (PA.effective_date, AA.assignment_id))
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

Line 209: pay_assignment_actions AA,

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
213: ('TRANSFER_PAYROLL_ACTION_ID')

Line 236: pay_assignment_actions AA,

232: FROM per_people_f PE,
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

Line 269: pay_assignment_actions AA,

265: (PA.effective_date, AA.assignment_id))
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

Line 348: pay_assignment_actions AA

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
352: AA.payroll_action_id = PA.payroll_action_id AND

Line 372: pay_assignment_actions AA,

368: 'JURISDICTION_CODE=C', PMC.jurisdiction_code
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

Line 398: pay_assignment_actions AA,

394: 'JURISDICTION_CODE=C', PSV.jurisdiction_code
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

Line 437: pay_assignment_actions paa,

433: SELECT 'TRANSFER_MESSAGE=P',
434: tuv.name || '-' || ppf.full_name||'('||ppf.employee_number||')'||fnd_global.local_chr(10)
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