eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_MOVDED_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 149: hr_organization_information hoi

145: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
146: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
147: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
148: from pay_payroll_actions pact,
149: hr_organization_information hoi
150: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
151: and pact.business_group_id = hoi.organization_id
152: and hoi.org_information_context = 'Tax Details References'
153: and nvl(hoi.org_information10,'UK') = 'UK'

Line 224: hr_organization_information hoi

220: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
221: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
222: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
223: from pay_payroll_actions pact,
224: hr_organization_information hoi
225: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
226: and pact.business_group_id = hoi.organization_id
227: and hoi.org_information_context = 'Tax Details References'
228: and nvl(hoi.org_information10,'UK') = 'UK'

Line 288: hr_organization_information hoi

284: 'TAX_DISTRICT=P', upper(hoi.org_information2),
285: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
286: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
287: from pay_payroll_actions pact,
288: hr_organization_information hoi
289: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
290: and pact.business_group_id = hoi.organization_id
291: and hoi.org_information_context = 'Tax Details References'
292: and nvl(hoi.org_information10,'UK') = 'UK'

Line 352: hr_organization_information hoi

348: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
349: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
350: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
351: from pay_payroll_actions pact,
352: hr_organization_information hoi
353: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
354: and pact.business_group_id = hoi.organization_id
355: and hoi.org_information_context = 'Tax Details References'
356: and nvl(hoi.org_information10,'UK') = 'UK'

Line 411: hr_organization_information hoi

407: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
408: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
409: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
410: from pay_payroll_actions pact,
411: hr_organization_information hoi
412: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
413: and pact.business_group_id = hoi.organization_id
414: and hoi.org_information_context = 'Tax Details References'
415: and nvl(hoi.org_information10,'UK') = 'UK'

Line 502: hr_organization_information hoi

498: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
499: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
500: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
501: from pay_payroll_actions pact,
502: hr_organization_information hoi
503: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
504: and pact.business_group_id = hoi.organization_id
505: and hoi.org_information_context = 'Tax Details References'
506: and nvl(hoi.org_information10,'UK') = 'UK'

Line 598: hr_organization_information hoi

594: 'TAX_DISTRICT=P', upper(hoi.org_information2),
595: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
596: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
597: from pay_payroll_actions pact,
598: hr_organization_information hoi
599: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
600: and pact.business_group_id = hoi.organization_id
601: and hoi.org_information_context = 'Tax Details References'
602: and nvl(hoi.org_information10,'UK') = 'UK'

Line 686: hr_organization_information hoi

682: 'TAX_DISTRICT=P', upper(hoi.org_information2),
683: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
684: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
685: from pay_payroll_actions pact,
686: hr_organization_information hoi
687: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
688: and pact.business_group_id = hoi.organization_id
689: and hoi.org_information_context = 'Tax Details References'
690: and nvl(hoi.org_information10,'UK') = 'UK'

Line 771: hr_organization_information hoi

767: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
768: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
769: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
770: from pay_payroll_actions pact,
771: hr_organization_information hoi
772: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
773: and pact.business_group_id = hoi.organization_id
774: and hoi.org_information_context = 'Tax Details References'
775: and nvl(hoi.org_information10,'UK') = 'UK'

Line 842: hr_organization_information hoi

838: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
839: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
840: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
841: from pay_payroll_actions pact,
842: hr_organization_information hoi
843: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
844: and pact.business_group_id = hoi.organization_id
845: and hoi.org_information_context = 'Tax Details References'
846: and nvl(hoi.org_information10,'UK') = 'UK'

Line 914: hr_organization_information hoi

910: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
911: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
912: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
913: from pay_payroll_actions pact,
914: hr_organization_information hoi
915: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
916: and pact.business_group_id = hoi.organization_id
917: and hoi.org_information_context = 'Tax Details References'
918: and nvl(hoi.org_information10,'UK') = 'UK'