167: ,hr_organization_information hoi
168: where ppa.payroll_action_id =
169: pay_magtape_generic.get_parameter_value(
170: 'TRANSFER_PAYROLL_ACTION_ID')
171: and exists (select 'x' from pay_assignment_Actions paa
172: where paa.payroll_action_id = ppa.payroll_action_id
173: and paa.tax_unit_id = hoi.organization_id
174: )
175: and hoi.org_information_context = 'Employer Identification'
219: )
220: and pai.tax_unit_id = pay_magtape_generic.get_parameter_value(
221: 'TRANSFER_TAX_UNIT_ID')
222: and exists (select 'x'
223: from pay_assignment_actions paa
224: where paa.payroll_action_id =
225: pay_magtape_generic.get_parameter_value(
226: 'TRANSFER_PAYROLL_ACTION_ID')
227: and paa.tax_unit_id =