APPS.GMIVDX dependencies on HR_ALL_ORGANIZATION_UNITS

Line 283: hr_all_organization_units h

279:
280: Cursor Cur_get_odm_fiscal_details (Vorganization_id NUMBER) IS
281: SELECT o.organization_code, o.set_of_books_id sob_id
282: FROM org_organization_definitions o,
283: hr_all_organization_units h
284: WHERE o.organization_id = Vorganization_id
285: AND h.organization_id = o.organization_id
286: AND sysdate between nvl(h.date_from, sysdate) and nvl(h.date_to,sysdate);
287: