APPS.GMIVDX dependencies on HR_ALL_ORGANIZATION_UNITS

Line 290: hr_all_organization_units h

286:
287: Cursor Cur_get_odm_fiscal_details (Vorganization_id NUMBER) IS
288: SELECT o.organization_code, o.set_of_books_id sob_id
289: FROM org_organization_definitions o,
290: hr_all_organization_units h
291: WHERE o.organization_id = Vorganization_id
292: AND h.organization_id = o.organization_id
293: AND sysdate between nvl(h.date_from, sysdate) and nvl(h.date_to,sysdate);
294: