DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 946: hr_all_organization_units hou -- GRE

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