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 81: pay_payroll_actions PPA,

77: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2),
78: 'ROOT_XML_TAG=P', ''
79: FROM pay_state_rules SR,
80: hr_organization_information HOI,
81: pay_payroll_actions PPA,
82: pay_payroll_actions PPA1
83: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
84: ('TRANSFER_PAYROLL_ACTION_ID')
85: AND ppa1.effective_date = ppa.effective_date

Line 82: pay_payroll_actions PPA1

78: 'ROOT_XML_TAG=P', ''
79: FROM pay_state_rules SR,
80: hr_organization_information HOI,
81: pay_payroll_actions PPA,
82: pay_payroll_actions PPA1
83: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
84: ('TRANSFER_PAYROLL_ACTION_ID')
85: AND ppa1.effective_date = ppa.effective_date
86: AND ppa1.report_qualifier = 'LOCAL'

Line 115: pay_payroll_actions ppa,

111: 'PAYROLL_ACTION_ID=P', ppa.payroll_action_id,
112: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
113: 'TAX_UNIT_NAME=P', hou.name
114: FROM hr_all_organization_units hou,
115: pay_payroll_actions ppa,
116: pay_assignment_actions aa
117: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
118: ('TRANSFER_PAYROLL_ACTION_ID')
119: AND ppa.report_type = 'YREND'

Line 149: pay_payroll_actions PA

145: per_all_assignments_f SS,
146: pay_action_interlocks AI,
147: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
148: pay_assignment_actions AA,
149: pay_payroll_actions PA
150: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND AA.payroll_action_id = PA.payroll_action_id
153: AND AI.locking_action_id = AA.assignment_action_id

Line 208: pay_payroll_actions PA

204: per_all_assignments_f SS,
205: pay_action_interlocks AI,
206: pay_assignment_actions AA1, -- for YE Archiver Assignment Actions
207: pay_assignment_actions AA,
208: pay_payroll_actions PA
209: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
210: ('TRANSFER_PAYROLL_ACTION_ID')
211: AND AA.payroll_action_id = PA.payroll_action_id
212: AND AI.locking_action_id = AA.assignment_action_id