DBA Data[Home] [Help]

APPS.PAY_IE_WNU_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 33: ,hr_organization_information hoi

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
37: AND hoi.organization_id=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_REF')