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_PAYROLL_ACTIONS

Line 86: pay_payroll_actions PPA,

82: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2),
83: 'ROOT_XML_TAG=P', ''
84: FROM pay_state_rules SR,
85: hr_organization_information HOI,
86: pay_payroll_actions PPA,
87: pay_payroll_actions PPA1
88: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
89: ('TRANSFER_PAYROLL_ACTION_ID')
90: AND ppa1.effective_date = ppa.effective_date

Line 87: pay_payroll_actions PPA1

83: 'ROOT_XML_TAG=P', ''
84: FROM pay_state_rules SR,
85: hr_organization_information HOI,
86: pay_payroll_actions PPA,
87: pay_payroll_actions PPA1
88: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
89: ('TRANSFER_PAYROLL_ACTION_ID')
90: AND ppa1.effective_date = ppa.effective_date
91: AND ppa1.report_qualifier = 'LOCAL'

Line 120: pay_payroll_actions ppa,

116: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
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'

Line 154: pay_payroll_actions PA

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
158: AND AI.locking_action_id = AA.assignment_action_id

Line 205: pay_payroll_actions PA

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
209: AND AI.locking_action_id = AA.assignment_action_id

Line 263: pay_payroll_actions PA

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
267: AND AI.locking_action_id = AA.assignment_action_id