28: ('EMPLOYER_ADDRESS3=P') , nvl(trim(rpad(hlo.address_line_3,30)),' '),
29: ('CONTACT_NAME=P') , nvl(trim(rpad(hoi.org_information4,20)),' '),
30: ('CONTACT_NUMBER=P') , nvl(trim(rpad(hlo.telephone_number_1,12)),' ')
31: FROM pay_payroll_actions ppa
32: ,hr_organization_units hou
33: ,hr_organization_information hoi
34: ,hr_locations_all hlo
35: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
36: AND hou.business_group_id= ppa.business_group_id