DBA Data[Home] [Help]

APPS.PAY_IE_WNU_EDI dependencies on HR_ORGANIZATION_UNITS

Line 32: ,hr_organization_units hou

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