DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on HR_OPERATING_UNITS

Line 945: FROM hr_operating_units hou

941: p_debug_info => l_debug_info
942: ) ;
943: SELECT COUNT(1)
944: INTO l_org_count
945: FROM hr_operating_units hou
946: WHERE L_SYSDATE BETWEEN NVL((TRUNC(hou.date_from)), L_SYSDATE)
947: AND NVL((TRUNC(hou.date_to) + .99999) - 1, L_SYSDATE)
948: AND hou.organization_id = p_org_id;
949: IF NVL(l_org_count, 0) = 0 THEN