APPS.PAY_US_PSD_XML dependencies on PER_ALL_ASSIGNMENTS_F

Line 148: per_all_assignments_f paf,

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
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND ppa.report_type = 'PSD_MAG_XML'

Line 176: per_all_assignments_f paf,--Added for the Bug 15944697

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
180: ('TRANSFER_PAYROLL_ACTION_ID')

Line 205: per_all_assignments_f paf,--Added for the Bug 15944697

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
209: ('TRANSFER_PAYROLL_ACTION_ID')

Line 243: per_all_assignments_f SS,

239: IS
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

Line 298: per_all_assignments_f paf,

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
301: AND paf.person_id=pap.person_id
302: AND pap.person_id=paa.serial_number