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_MMREF_REPORTING1 dependencies on PAY_PAYROLL_ACTIONS

Line 97: pay_payroll_actions PPA,

93: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
94: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
95: FROM pay_state_rules SR,
96: hr_organization_information HOI,
97: pay_payroll_actions PPA,
98: pay_payroll_actions PPA1
99: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
100: ('TRANSFER_PAYROLL_ACTION_ID')
101: AND ppa1.effective_date = ppa.effective_date

Line 98: pay_payroll_actions PPA1

94: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
95: FROM pay_state_rules SR,
96: hr_organization_information HOI,
97: pay_payroll_actions PPA,
98: pay_payroll_actions PPA1
99: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
100: ('TRANSFER_PAYROLL_ACTION_ID')
101: AND ppa1.effective_date = ppa.effective_date
102: AND ppa1.report_qualifier = sr.state_code

Line 148: pay_payroll_actions PPA

144: 'TRANSFER_2678_FILER=P', HOI.org_information8,
145: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id, -- payroll_action_id of YREND
146: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
147: FROM hr_organization_information HOI,
148: pay_payroll_actions PPA
149: WHERE HOI.organization_id =
150: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
151: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'
152: AND HOI.org_information_context = 'W2 Reporting Rules'

Line 193: pay_payroll_actions ppa,

189: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
190: 'TAX_UNIT_NAME=P' , hou.name,
191: 'TRANSFER_EMP_CODE=P', 'R'
192: FROM hr_all_organization_units hou,
193: pay_payroll_actions ppa,
194: pay_assignment_actions AA
195: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
196: ('TRANSFER_PAYROLL_ACTION_ID')
197: AND ppa.report_type = 'YREND'

Line 217: pay_payroll_actions ppa,

213: 'TAX_UNIT_NAME=P' , hou.name,
214: 'TRANSFER_EMP_CODE=P', 'R',
215: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
216: FROM hr_all_organization_units hou,
217: pay_payroll_actions ppa,
218: pay_assignment_actions AA
219: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')
221: AND ppa.report_type = 'YREND'

Line 242: pay_payroll_actions ppa,

238: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
239: 'TAX_UNIT_NAME=P', hou.name,
240: 'TRANSFER_EMP_CODE=P' , 'R'
241: FROM hr_all_organization_units hou,
242: pay_payroll_actions ppa,
243: pay_assignment_actions AA
244: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
245: ('TRANSFER_PAYROLL_ACTION_ID')
246: AND ppa.report_type = 'YREND'

Line 264: pay_payroll_actions ppa,

260: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
261: 'TAX_UNIT_NAME=P', hou.name,
262: 'TRANSFER_EMP_CODE=P' , 'Q'
263: FROM hr_all_organization_units hou,
264: pay_payroll_actions ppa,
265: pay_assignment_actions AA
266: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
267: ('TRANSFER_PAYROLL_ACTION_ID')
268: AND ppa.report_type = 'YREND'

Line 314: pay_payroll_actions PA

310: FROM per_all_people_f PE,
311: per_all_assignments_f SS,
312: pay_action_interlocks AI,
313: pay_assignment_actions AA,
314: pay_payroll_actions PA
315: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
316: ('TRANSFER_PAYROLL_ACTION_ID')
317: AND AA.payroll_action_id = PA.payroll_action_id
318: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 348: pay_payroll_actions PA,

344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,
349: ff_archive_items arch,
350: ff_user_entities fue
351: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
352: ('TRANSFER_PAYROLL_ACTION_ID')

Line 395: pay_payroll_actions PA

391: FROM per_all_people_f PE,
392: per_all_assignments_f SS,
393: pay_action_interlocks AI,
394: pay_assignment_actions AA,
395: pay_payroll_actions PA
396: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
397: ('TRANSFER_PAYROLL_ACTION_ID')
398: AND AA.payroll_action_id = PA.payroll_action_id
399: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 484: pay_payroll_actions PA

480: FROM per_all_people_f PE,
481: per_all_assignments_f SS,
482: pay_action_interlocks AI,
483: pay_assignment_actions AA,
484: pay_payroll_actions PA
485: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
486: ('TRANSFER_PAYROLL_ACTION_ID')
487: AND aa.assignment_action_id = pay_magtape_generic.get_parameter_value(
488: 'TRANSFER_ACT_ID')