APPS.PAY_GB_DEO dependencies on HR_ORGANIZATION_INFORMATION

Line 751: hr_organization_information hoi

747: fnd_number.number_to_canonical(pact.request_id) request_id,
748: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
749: nvl(substr(hoi.org_information20,1,12),' ') employer_no
750: from pay_payroll_actions pact,
751: hr_organization_information hoi
752: where payroll_action_id = pactid
753: and pact.business_group_id = hoi.organization_id
754: and hoi.org_information_context = 'Tax Details References'
755: and nvl(hoi.org_information10,'UK') = 'UK'

Line 808: from hr_organization_information hoi

804: select nvl(hoi.org_information11,' ') sender_id,
805: nvl(upper(hoi.org_information2),' ') hrmc_office,
806: nvl(upper(hoi.org_information4),' ') er_addr,
807: nvl(upper(hoi.org_information3),' ') er_name
808: from hr_organization_information hoi
809: where hoi.organization_id = p_bus_id
810: and hoi.org_information_context = 'Tax Details References'
811: and nvl(hoi.org_information10,'UK') = 'UK'
812: and upper(hoi.org_information1) = upper(p_tax_ref);