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

Line 60: pay_payroll_actions PPA,

56: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
57: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
58: FROM pay_state_rules SR,
59: hr_organization_information HOI,
60: pay_payroll_actions PPA,
61: pay_payroll_actions PPA1
62: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
63: ('TRANSFER_PAYROLL_ACTION_ID')
64: AND ppa1.effective_date = ppa.effective_date

Line 61: pay_payroll_actions PPA1

57: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
58: FROM pay_state_rules SR,
59: hr_organization_information HOI,
60: pay_payroll_actions PPA,
61: pay_payroll_actions PPA1
62: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
63: ('TRANSFER_PAYROLL_ACTION_ID')
64: AND ppa1.effective_date = ppa.effective_date
65: AND ppa1.report_qualifier = sr.state_code

Line 111: pay_payroll_actions PPA

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

Line 156: pay_payroll_actions ppa,

152: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
153: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
154: 'TRANSFER_EMP_CODE=P', 'R'
155: FROM hr_all_organization_units hou,
156: pay_payroll_actions ppa,
157: pay_assignment_actions AA
158: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
159: ('TRANSFER_PAYROLL_ACTION_ID')
160: AND ppa.report_type = 'YREND'

Line 180: pay_payroll_actions ppa,

176: 'TAX_UNIT_NAME=P' , substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
177: 'TRANSFER_EMP_CODE=P', 'R',
178: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
179: FROM hr_all_organization_units hou,
180: pay_payroll_actions ppa,
181: pay_assignment_actions AA
182: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_PAYROLL_ACTION_ID')
184: AND ppa.report_type = 'YREND'

Line 205: pay_payroll_actions ppa,

201: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
202: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
203: 'TRANSFER_EMP_CODE=P' , 'R'
204: FROM hr_all_organization_units hou,
205: pay_payroll_actions ppa,
206: pay_assignment_actions AA
207: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
208: ('TRANSFER_PAYROLL_ACTION_ID')
209: AND ppa.report_type = 'YREND'

Line 227: pay_payroll_actions ppa,

223: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
224: 'TAX_UNIT_NAME=P', substr(hou.name,1,80), -- Bug# 14286448 Gre length issue
225: 'TRANSFER_EMP_CODE=P' , 'Q'
226: FROM hr_all_organization_units hou,
227: pay_payroll_actions ppa,
228: pay_assignment_actions AA
229: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
230: ('TRANSFER_PAYROLL_ACTION_ID')
231: AND ppa.report_type = 'YREND'

Line 277: pay_payroll_actions PA

273: FROM per_all_people_f PE,
274: per_all_assignments_f SS,
275: pay_action_interlocks AI,
276: pay_assignment_actions AA,
277: pay_payroll_actions PA
278: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
279: ('TRANSFER_PAYROLL_ACTION_ID')
280: AND AA.payroll_action_id = PA.payroll_action_id
281: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 310: pay_payroll_actions PA,

306: per_all_assignments_f SS,
307: pay_action_interlocks AI,
308: pay_assignment_actions AA,
309: pay_assignment_actions paa,
310: pay_payroll_actions PA,
311: ff_archive_items arch,
312: ff_user_entities fue
313: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
314: ('TRANSFER_PAYROLL_ACTION_ID')

Line 357: pay_payroll_actions PA

353: FROM per_all_people_f PE,
354: per_all_assignments_f SS,
355: pay_action_interlocks AI,
356: pay_assignment_actions AA,
357: pay_payroll_actions PA
358: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
359: ('TRANSFER_PAYROLL_ACTION_ID')
360: AND AA.payroll_action_id = PA.payroll_action_id
361: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 446: pay_payroll_actions PA

442: FROM per_all_people_f PE,
443: per_all_assignments_f SS,
444: pay_action_interlocks AI,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')
449: AND aa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
450: AND AA.payroll_action_id = PA.payroll_action_id