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

Line 225: hr_organization_information org

221: substr(ltrim(org.org_information3),1,36) employers_name,
222: substr(ltrim(org.org_information4),1,60) employers_address_line
223: FROM pay_all_payrolls_f p,
224: hr_soft_coding_keyflex flex,
225: hr_organization_information org
226: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
227: AND org.org_information_context = 'Tax Details References'
228: AND org.org_information1 = flex.segment1
229: AND NVL(org.org_information10,'UK') = 'UK'

Line 3088: hr_organization_information org

3084: substr(nvl(flex.segment14,org.org_information7),1,9) econ
3085:
3086: FROM pay_all_payrolls_f p,
3087: hr_soft_coding_keyflex flex,
3088: hr_organization_information org
3089: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3090: AND org.org_information_context = 'Tax Details References'
3091: AND org.org_information1 = flex.segment1
3092: AND NVL(org.org_information10,'UK') = 'UK'

Line 3606: l_sender_id hr_organization_information.org_information11%TYPE;

3602: p_payroll_action_id IN NUMBER)
3603: IS
3604: error_found EXCEPTION;
3605: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
3606: l_sender_id hr_organization_information.org_information11%TYPE;
3607: l_tax_ref hr_organization_information.org_information1%TYPE;
3608: l_tax_dist hr_organization_information.org_information2%TYPE;
3609: l_employer_addr VARCHAR2(255);
3610: l_employer_name VARCHAR2(150);

Line 3607: l_tax_ref hr_organization_information.org_information1%TYPE;

3603: IS
3604: error_found EXCEPTION;
3605: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
3606: l_sender_id hr_organization_information.org_information11%TYPE;
3607: l_tax_ref hr_organization_information.org_information1%TYPE;
3608: l_tax_dist hr_organization_information.org_information2%TYPE;
3609: l_employer_addr VARCHAR2(255);
3610: l_employer_name VARCHAR2(150);
3611: l_err BOOLEAN;

Line 3608: l_tax_dist hr_organization_information.org_information2%TYPE;

3604: error_found EXCEPTION;
3605: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
3606: l_sender_id hr_organization_information.org_information11%TYPE;
3607: l_tax_ref hr_organization_information.org_information1%TYPE;
3608: l_tax_dist hr_organization_information.org_information2%TYPE;
3609: l_employer_addr VARCHAR2(255);
3610: l_employer_name VARCHAR2(150);
3611: l_err BOOLEAN;
3612: l_exp EXCEPTION;

Line 3656: hr_organization_information hoi

3652: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
3653: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
3654: report_type
3655: FROM pay_payroll_actions pact,
3656: hr_organization_information hoi
3657: WHERE pact.payroll_action_id =pactid
3658: AND pact.business_group_id = hoi.organization_id
3659: AND hoi.org_information_context = 'Tax Details References'
3660: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 4500: hr_organization_information hoi

4496: pact.business_group_id bus_grp_id,
4497: pact.action_parameter_group_id act_param_grp_id,
4498: org_information19 service_company
4499: FROM pay_payroll_actions pact,
4500: hr_organization_information hoi
4501: WHERE pact.payroll_action_id =pactid
4502: AND pact.business_group_id = hoi.organization_id
4503: AND hoi.org_information_context = 'Tax Details References'
4504: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 4547: FROM hr_organization_information hoi

4543: SELECT NVL(hoi.org_information11,' ') sender_id,
4544: NVL(upper(hoi.org_information2),' ') hrmc_office,
4545: NVL(upper(hoi.org_information4),' ') er_addr,
4546: NVL(upper(hoi.org_information3),' ') er_name
4547: FROM hr_organization_information hoi
4548: WHERE hoi.organization_id = p_bus_id
4549: AND hoi.org_information_context = 'Tax Details References'
4550: AND NVL(hoi.org_information10,'UK') = 'UK'
4551: AND upper(hoi.org_information1) = upper(p_tax_ref);