DBA Data[Home] [Help]

APPS.GMIVDX dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 289: FROM org_organization_definitions o,

285: AND p.co_code = o.co_code;
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);