DBA Data[Home] [Help]

APPS.OKL_SUB_PVT dependencies on HR_OPERATING_UNITS

Line 842: FROM hr_operating_units hou

838: p_org_id IN NUMBER) IS
839:
840: CURSOR hou_csr (p_org_id in number) IS
841: SELECT 'Y'
842: FROM hr_operating_units hou
843: WHERE hou.organization_id = p_org_id
844: And sysdate between nvl(hou.date_from,sysdate) and nvl(hou.date_to,sysdate);
845:
846: l_exists varchar2(1) default 'N';