APPS.PAY_GB_MOVDED_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 1510: hr_organization_information hoi

1506: upper(hoi.org_information2),
1507: upper(hoi.org_information3),
1508: upper(hoi.org_information4)
1509: from pay_payroll_actions pact,
1510: hr_organization_information hoi
1511: where pact.payroll_action_id = p_payroll_action_id
1512: and pact.business_group_id = hoi.organization_id
1513: and hoi.org_information_context = 'Tax Details References'
1514: and (hoi.org_information10 is null

Line 1796: from hr_organization_information hoi

1792: select nvl(hoi.org_information11,' ') sender_id,
1793: nvl(upper(hoi.org_information2),' ') hrmc_office,
1794: nvl(upper(hoi.org_information4),' ') er_addr,
1795: nvl(upper(hoi.org_information3),' ') er_name
1796: from hr_organization_information hoi
1797: where hoi.organization_id = p_bus_id
1798: and hoi.org_information_context = 'Tax Details References'
1799: and nvl(hoi.org_information10,'UK') = 'UK'
1800: and upper(hoi.org_information1) = upper(p_tax_ref);