APPS.PAY_GB_WNU_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 531: hr_organization_information hoi

527: cursor csr_sender_id is
528: select hoi.org_information11,
529: hoi.org_information1
530: from pay_payroll_actions pact,
531: hr_organization_information hoi
532: where pact.payroll_action_id = p_payroll_action_id
533: and pact.business_group_id = hoi.organization_id
534: and hoi.org_information_context = 'Tax Details References'
535: and (hoi.org_information10 is null

Line 681: from hr_organization_information hoi

677: select nvl(hoi.org_information11,' ') sender_id,
678: nvl(upper(hoi.org_information2),' ') hrmc_office,
679: nvl(upper(hoi.org_information4),' ') er_addr,
680: nvl(upper(hoi.org_information3),' ') er_name
681: from hr_organization_information hoi
682: where hoi.organization_id = p_bus_id
683: and hoi.org_information_context = 'Tax Details References'
684: and nvl(hoi.org_information10,'UK') = 'UK'
685: and upper(hoi.org_information1) = upper(p_tax_ref);