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_LOCAL_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 121: pay_assignment_actions aa

117: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
118: 'TAX_UNIT_NAME=P', substr(hou.name,1,80) -- Bug# 14286448 Gre length issue
119: FROM hr_all_organization_units hou,
120: pay_payroll_actions ppa,
121: pay_assignment_actions aa
122: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
123: ('TRANSFER_PAYROLL_ACTION_ID')
124: AND ppa.report_type = 'YREND'
125: AND to_char(ppa.effective_date, 'YYYY') =

Line 152: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

148: ff_archive_item_contexts FAIC,
149: per_all_people_f PE,
150: per_all_assignments_f SS,
151: pay_action_interlocks AI,
152: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
153: pay_assignment_actions AA,
154: pay_payroll_actions PA
155: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
156: ('TRANSFER_PAYROLL_ACTION_ID')

Line 153: pay_assignment_actions AA,

149: per_all_people_f PE,
150: per_all_assignments_f SS,
151: pay_action_interlocks AI,
152: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
153: pay_assignment_actions AA,
154: pay_payroll_actions PA
155: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
156: ('TRANSFER_PAYROLL_ACTION_ID')
157: AND AA.payroll_action_id = PA.payroll_action_id

Line 203: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

199: ff_archive_item_contexts FAIC,
200: per_all_people_f PE,
201: per_all_assignments_f SS,
202: pay_action_interlocks AI,
203: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
204: pay_assignment_actions AA,
205: pay_payroll_actions PA
206: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')

Line 204: pay_assignment_actions AA,

200: per_all_people_f PE,
201: per_all_assignments_f SS,
202: pay_action_interlocks AI,
203: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
204: pay_assignment_actions AA,
205: pay_payroll_actions PA
206: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
207: ('TRANSFER_PAYROLL_ACTION_ID')
208: AND AA.payroll_action_id = PA.payroll_action_id

Line 261: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions

257: ff_archive_item_contexts FAIC,
258: per_all_people_f PE,
259: per_all_assignments_f SS,
260: pay_action_interlocks AI,
261: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
262: pay_assignment_actions AA,
263: pay_payroll_actions PA
264: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
265: ('TRANSFER_PAYROLL_ACTION_ID')

Line 262: pay_assignment_actions AA,

258: per_all_people_f PE,
259: per_all_assignments_f SS,
260: pay_action_interlocks AI,
261: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
262: pay_assignment_actions AA,
263: pay_payroll_actions PA
264: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
265: ('TRANSFER_PAYROLL_ACTION_ID')
266: AND AA.payroll_action_id = PA.payroll_action_id

Line 364: FROM pay_assignment_actions paa

360: FROM DUAL;
361:
362: CURSOR LOCAL_MAG_ASG_ACT IS
363: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
364: FROM pay_assignment_actions paa
365: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
366: 'TRANSFER_PAYROLL_ACTION_ID');
367: --
368: -- Follwing Procedures are used for constructing XML for Submitter or RA Record