DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1622: hr_all_organization_units hou

1618: from dual
1619: where not exists(
1620: select null
1621: from hr_organization_information hoi,
1622: hr_all_organization_units hou
1623: where hoi.org_information_context = 'CLASS'
1624: and hoi.org_information1 = 'JP_TAX_SWOT'
1625: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)
1626: and hou.organization_id = hoi.organization_id