DBA Data[Home] [Help]

APPS.PAY_GB_WNU_EDI_BIP dependencies on HR_ORGANIZATION_INFORMATION

Line 13: hr_organization_information hoi

9:
10: cursor empl_address_line is
11: select nvl(upper(hoi.org_information4),' ') employers_address_line
12: from pay_payroll_actions pact,
13: hr_organization_information hoi
14: where pact.payroll_action_id = p_payroll_action_id
15: and pact.business_group_id = hoi.organization_id
16: and hoi.org_information_context = 'Tax Details References'
17: and nvl(hoi.org_information10,'UK') = 'UK'