APPS.PAY_US_MAGW2_REPORTING dependencies on HR_ORGANIZATION_UNITS
Line 196: hr_organization_units hou
192: -- Cursor to get all the GREs belonging to the given business group
193: CURSOR c_get_gre IS
194: SELECT hou.organization_id gre
195: FROM hr_organization_information hoi, 196: hr_organization_units hou 197: WHERE hou.business_group_id+0 = p_business_group_id AND
198: hoi.organization_id = hou.organization_id AND
199: hoi.org_information_context = 'CLASS' AND
200: hoi.org_information1 = 'HR_LEGAL' AND