DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 22834: FROM hr_all_organization_units

22830: l_item_id NUMBER;
22831:
22832: CURSOR org_csr (p_inventory_org_id NUMBER) IS
22833: SELECT organization_id
22834: FROM hr_all_organization_units
22835: WHERE organization_id = p_inventory_org_id
22836: AND SYSDATE BETWEEN NVL(date_from, SYSDATE) AND NVL(date_to, SYSDATE);
22837:
22838: /*

Line 22842: FROM hr_all_organization_units

22838: /*
22839: CURSOR org_csr (p_inventory_org_name VARCHAR2,
22840: p_inventory_org_id NUMBER) IS
22841: SELECT organization_id
22842: FROM hr_all_organization_units
22843: WHERE ((name = p_inventory_org_name
22844: AND
22845: p_inventory_org_name IS NOT NULL)
22846: OR