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

Line 125: pay_assignment_actions aa,

121: 'TAX_UNIT_NAME=P', hou.name,
122: 'ER_PSD_CODE=P' , substr(hoi.ORG_INFORMATION10,1,6)
123: FROM hr_all_organization_units hou,
124: pay_payroll_actions ppa,
125: pay_assignment_actions aa,
126: hr_organization_information hoi
127: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value
128: ('TRANSFER_PAYROLL_ACTION_ID')
129: AND ppa.report_type = 'PSD_MAG_XML'

Line 146: pay_assignment_actions aa,

142: 'TAX_UNIT_NAME=P', hou.name,
143: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
144: FROM hr_all_organization_units hou,
145: pay_payroll_actions ppa,
146: pay_assignment_actions aa,
147: hr_organization_information hoi,
148: per_all_assignments_f paf,
149: pay_us_asg_reporting puar
150: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 175: pay_assignment_actions aa,

171: 'TAX_UNIT_NAME=P', hou.name,
172: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
173: FROM hr_all_organization_units hou,
174: pay_payroll_actions ppa,
175: pay_assignment_actions aa,
176: per_all_assignments_f paf,--Added for the Bug 15944697
177: hr_organization_information hoi,
178: pay_us_asg_reporting puar
179: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 204: pay_assignment_actions aa,

200: 'TAX_UNIT_NAME=P', hou.name,
201: 'ER_PSD_CODE=P' , substr(puar.jurisdiction_code, 11,6)
202: FROM hr_all_organization_units hou,
203: pay_payroll_actions ppa,
204: pay_assignment_actions aa,
205: per_all_assignments_f paf,--Added for the Bug 15944697
206: hr_organization_information hoi,
207: pay_us_asg_reporting puar
208: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 244: pay_assignment_actions AA,

240: SELECT DISTINCT
241: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
242: FROM per_all_people_f PE,
243: per_all_assignments_f SS,
244: pay_assignment_actions AA,
245: pay_payroll_actions PA ,
246: pay_us_asg_reporting puar
247: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
248: ('TRANSFER_PAYROLL_ACTION_ID')

Line 275: pay_assignment_actions paa

271: /*SELECT DISTINCT 'TRANSFER_ACT_ID=P',
272: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'),
273: 'TRANSFER_EE_JD_CODE=P', puar.jurisdiction_code
274: FROM pay_us_asg_reporting puar,
275: pay_assignment_actions paa
276: WHERE puar.assignment_id=paa.assignment_id
277: AND paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
278: AND length(puar.jurisdiction_code)=16
279: AND EXISTS ( select null

Line 296: pay_assignment_actions paa,

292: SELECT DISTINCT 'TRANSFER_ACT_ID=P',
293: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'),
294: 'TRANSFER_EE_JD_CODE=P', puar.jurisdiction_code
295: FROM pay_us_asg_reporting puar,
296: pay_assignment_actions paa,
297: per_all_people_f pap,
298: per_all_assignments_f paf,
299: pay_payroll_actions ppa
300: WHERE puar.assignment_id=paf.assignment_id