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_RTI_EYU dependencies on HR_ORGANIZATION_INFORMATION

Line 2543: hr_organization_information hoi

2539: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2540: hoi.org_information7 econ
2541:
2542: from pay_payroll_actions pact,
2543: hr_organization_information hoi
2544: where pact.payroll_action_id=pactid
2545: and pact.business_group_id = hoi.organization_id
2546: and hoi.org_information_context = 'Tax Details References'
2547: and nvl(hoi.org_information10,'UK') = 'UK'

Line 4588: l_sender_id hr_organization_information.org_information11%TYPE;

4584: p_payroll_action_id IN NUMBER)
4585: IS
4586: error_found EXCEPTION;
4587: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
4588: l_sender_id hr_organization_information.org_information11%TYPE;
4589: l_tax_ref hr_organization_information.org_information1%TYPE;
4590: l_tax_dist hr_organization_information.org_information2%TYPE;
4591: l_employer_addr VARCHAR2(255);
4592: l_employer_name VARCHAR2(150);

Line 4589: l_tax_ref hr_organization_information.org_information1%TYPE;

4585: IS
4586: error_found EXCEPTION;
4587: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
4588: l_sender_id hr_organization_information.org_information11%TYPE;
4589: l_tax_ref hr_organization_information.org_information1%TYPE;
4590: l_tax_dist hr_organization_information.org_information2%TYPE;
4591: l_employer_addr VARCHAR2(255);
4592: l_employer_name VARCHAR2(150);
4593: l_err BOOLEAN;

Line 4590: l_tax_dist hr_organization_information.org_information2%TYPE;

4586: error_found EXCEPTION;
4587: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
4588: l_sender_id hr_organization_information.org_information11%TYPE;
4589: l_tax_ref hr_organization_information.org_information1%TYPE;
4590: l_tax_dist hr_organization_information.org_information2%TYPE;
4591: l_employer_addr VARCHAR2(255);
4592: l_employer_name VARCHAR2(150);
4593: l_err BOOLEAN;
4594: l_exp EXCEPTION;

Line 4618: hr_organization_information hoi

4614: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
4615: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
4616: report_type
4617: FROM pay_payroll_actions pact,
4618: hr_organization_information hoi
4619: WHERE pact.payroll_action_id =pactid
4620: AND pact.business_group_id = hoi.organization_id
4621: AND hoi.org_information_context = 'Tax Details References'
4622: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 5764: hr_organization_information hoi

5760: pact.business_group_id bus_grp_id,
5761: pact.action_parameter_group_id act_param_grp_id,
5762: org_information19 service_company
5763: FROM pay_payroll_actions pact,
5764: hr_organization_information hoi
5765: WHERE pact.payroll_action_id =pactid
5766: AND pact.business_group_id = hoi.organization_id
5767: AND hoi.org_information_context = 'Tax Details References'
5768: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 5813: FROM hr_organization_information hoi

5809: SELECT NVL(hoi.org_information11,' ') sender_id,
5810: NVL(upper(hoi.org_information2),' ') hrmc_office,
5811: NVL(upper(hoi.org_information4),' ') er_addr,
5812: NVL(upper(hoi.org_information3),' ') er_name
5813: FROM hr_organization_information hoi
5814: WHERE hoi.organization_id = p_bus_id
5815: AND hoi.org_information_context = 'Tax Details References'
5816: AND NVL(hoi.org_information10,'UK') = 'UK'
5817: AND upper(hoi.org_information1) = upper(p_tax_ref);