APPS.PAY_US_MMREF_REPORTING_MT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 217: hr_all_organization_units hou

213: -- Cursor to get all the GREs belonging to the given business group
214: CURSOR c_get_gre IS
215: SELECT hou.organization_id gre
216: FROM hr_organization_information hoi,
217: hr_all_organization_units hou
218: WHERE hou.business_group_id = p_business_group_id AND
219: hoi.organization_id = hou.organization_id AND
220: hoi.org_information_context = 'CLASS' AND
221: hoi.org_information1 = 'HR_LEGAL' AND