APPS.PAY_GB_MOVDED_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 127: hr_organization_information hoi

123: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
124: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
125: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
126: from pay_payroll_actions pact,
127: hr_organization_information hoi
128: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
129: and pact.business_group_id = hoi.organization_id
130: and hoi.org_information_context = 'Tax Details References'
131: and nvl(hoi.org_information10,'UK') = 'UK'

Line 202: hr_organization_information hoi

198: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
199: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
200: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
201: from pay_payroll_actions pact,
202: hr_organization_information hoi
203: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
204: and pact.business_group_id = hoi.organization_id
205: and hoi.org_information_context = 'Tax Details References'
206: and nvl(hoi.org_information10,'UK') = 'UK'

Line 266: hr_organization_information hoi

262: 'TAX_DISTRICT=P', upper(hoi.org_information2),
263: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
264: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
265: from pay_payroll_actions pact,
266: hr_organization_information hoi
267: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
268: and pact.business_group_id = hoi.organization_id
269: and hoi.org_information_context = 'Tax Details References'
270: and nvl(hoi.org_information10,'UK') = 'UK'

Line 329: hr_organization_information hoi

325: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
326: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
327: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
328: from pay_payroll_actions pact,
329: hr_organization_information hoi
330: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
331: and pact.business_group_id = hoi.organization_id
332: and hoi.org_information_context = 'Tax Details References'
333: and nvl(hoi.org_information10,'UK') = 'UK'

Line 388: hr_organization_information hoi

384: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
385: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
386: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
387: from pay_payroll_actions pact,
388: hr_organization_information hoi
389: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
390: and pact.business_group_id = hoi.organization_id
391: and hoi.org_information_context = 'Tax Details References'
392: and nvl(hoi.org_information10,'UK') = 'UK'

Line 484: hr_organization_information hoi

480: 'TAX_DISTRICT=P', upper(hoi.org_information2),
481: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
482: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
483: from pay_payroll_actions pact,
484: hr_organization_information hoi
485: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
486: and pact.business_group_id = hoi.organization_id
487: and hoi.org_information_context = 'Tax Details References'
488: and nvl(hoi.org_information10,'UK') = 'UK'

Line 565: hr_organization_information hoi

561: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
562: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
563: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
564: from pay_payroll_actions pact,
565: hr_organization_information hoi
566: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
567: and pact.business_group_id = hoi.organization_id
568: and hoi.org_information_context = 'Tax Details References'
569: and nvl(hoi.org_information10,'UK') = 'UK'