APPS.PAY_GB_WNU_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 526: hr_organization_information hoi

522: cursor csr_sender_id is
523: select hoi.org_information11,
524: hoi.org_information1
525: from pay_payroll_actions pact,
526: hr_organization_information hoi
527: where pact.payroll_action_id = p_payroll_action_id
528: and pact.business_group_id = hoi.organization_id
529: and hoi.org_information_context = 'Tax Details References'
530: and (hoi.org_information10 is null

Line 664: from hr_organization_information hoi

660: select nvl(hoi.org_information11,' ') sender_id,
661: nvl(upper(hoi.org_information2),' ') hrmc_office,
662: nvl(upper(hoi.org_information4),' ') er_addr,
663: nvl(upper(hoi.org_information3),' ') er_name
664: from hr_organization_information hoi
665: where hoi.organization_id = p_bus_id
666: and hoi.org_information_context = 'Tax Details References'
667: and nvl(hoi.org_information10,'UK') = 'UK'
668: and upper(hoi.org_information1) = upper(p_tax_ref);