DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 22645: FROM hr_all_organization_units

22641: l_item_id NUMBER;
22642:
22643: CURSOR org_csr (p_inventory_org_id NUMBER) IS
22644: SELECT organization_id
22645: FROM hr_all_organization_units
22646: WHERE organization_id = p_inventory_org_id
22647: AND SYSDATE BETWEEN NVL(date_from, SYSDATE) AND NVL(date_to, SYSDATE);
22648:
22649: /*

Line 22653: FROM hr_all_organization_units

22649: /*
22650: CURSOR org_csr (p_inventory_org_name VARCHAR2,
22651: p_inventory_org_id NUMBER) IS
22652: SELECT organization_id
22653: FROM hr_all_organization_units
22654: WHERE ((name = p_inventory_org_name
22655: AND
22656: p_inventory_org_name IS NOT NULL)
22657: OR