DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI dependencies on PAY_PAYROLL_ACTIONS

Line 64: FROM pay_payroll_actions pact,

60: 'FORMAT_TYPE=P', 'WNU',
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'