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_PAYROLL_ACTIONS

Line 104: pay_payroll_actions ppa

100: 'TRANSFER_STATE_CODE=P', substr (sr.jurisdiction_code, 1 , 2),
101: 'ROOT_XML_TAG=P', ''
102: FROM pay_state_rules sr,
103: hr_organization_information hoi,
104: pay_payroll_actions ppa
105: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID')
106: AND ppa.report_qualifier = 'LOCAL'
107: AND hoi.organization_id = pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID')
108: AND sr.state_code = pay_magtape_generic.get_parameter_value ('TRANSFER_STATE')

Line 124: pay_payroll_actions ppa,

120: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
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')

Line 145: pay_payroll_actions ppa,

141: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
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

Line 174: pay_payroll_actions ppa,

170: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
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

Line 203: pay_payroll_actions ppa,

199: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
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

Line 245: pay_payroll_actions PA ,

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')
249: AND AA.payroll_action_id = PA.payroll_action_id

Line 299: pay_payroll_actions ppa

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
301: AND paf.person_id=pap.person_id
302: AND pap.person_id=paa.serial_number
303: AND paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')