DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 65: hr_organization_information hoi

61: 'VERSION=P', '1.0',
62: 'TAX_DIST_NO=P', upper(substr(hoi.org_information1,1,3)),
63: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/') ,1,10))
64: FROM pay_payroll_actions pact,
65: hr_organization_information hoi
66: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
67: AND hoi.org_information_context = 'Tax Details References'
68: AND NVL(hoi.org_information10,'UK') = 'UK'
69: AND hoi.organization_id = pact.business_group_id