APPS.OKL_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 288: FROM hr_all_organization_units hou -- gboomina modified for Bug 6691305

284: l_sysdate DATE := SYSDATE;
285:
286: CURSOR C1 IS
287: SELECT 'S'
288: FROM hr_all_organization_units hou -- gboomina modified for Bug 6691305
289: WHERE hou.organization_id = TO_NUMBER(p_org_id)
290: AND l_sysdate BETWEEN NVL (hou.date_from, l_sysdate)
291: AND NVL (hou.date_to, l_sysdate);
292: