DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 942: hr_all_organization_units hou -- GRE

938: into l_tax_group
939: from
940: hr_organization_information hoi_bg, -- Business Group
941: hr_organization_information hoi_gre, -- US or CA Context
942: hr_all_organization_units hou -- GRE
943: where hou.organization_id = to_number(p_context_value)
944: and hoi_gre.organization_id = hou.organization_id
945: and hoi_bg.organization_id = hou.business_group_id
946: and hoi_gre.org_information_context =